Need help pulling info from multiple sheets to one sheet based on matching criteria

I have a spreadsheet comprised of multiple pricing sheets. I am trying to make a price tag on its own sheet. I would like to enter a model number on the price tag and have model detail pull from the pricing sheets and fill in my price tag.  I'm really not sure where to begin. I'm a little worried that i have merged cell on the pricing sheets and that may be an issue...

I'd really appreciate an guidance.

-T

If I understand you correctly, you have a variety of information about each object being priced, one object per sheet. If the locations of each bit of information is consistent, you could set up a series of formulas on your price tag sheet that refer to the locations. You would use the INDIRECT function to determine which tab is being referred to.

Example: =INDIRECT(c1&"!A1")

In C1, you would have data validation referring to a list of possible sheet names. You click on the drop down that results, and your formula automatically changes to A1 on a different sheet. The key to making this work is being consistent with adding sheet names into the list that is used for validation.