A search and display function to pull information from other worksheets

[BadbBalor]

I have an excel book with about 15 pages of information and I would like to use a list for someone to select a model of device and then have in another cell display or list all the workbook pages by title of page that have that model listed on them. Is this possible and where do I start, I have all my lists made containing all possible models. I am sorry if this is normally an easy thing to do I have never really used excel before but I'm a quick learner

 

[BadbBalor]

I also need help with renaming a list I previously made

 

[BadbBalor]

I acually found a fix for my problem, If anyone else has the same thing this is what I did, Its not exactly what I wanted but its good enough.

I used

=HLOOKUP(E9,'FORM2'!A1:R40,MATCH(C9,'FORM2'!A1:A100,0),)

E9 is a list i have the the person will choose from
C9 is another list that goes across all forms at the top

This way even though not every form is correct i can have the same equation just using different form names to create the list of what stores have what parts.

Example
If someone is looking for an outer housing for a 280 they can select the manufacturer, then select the model(C9) then they select the part(E9) then I have my list of what stores have what and they will populate how many each store has. I used the Match function to find what row each model is on, and then using the Hlookup function it displays the contents of the cell found using the row the model is in and the column the part is in. works well