searching of multiple tabs and list matches

[manning]

Hi Everyone, hope someone can help, looked everywhere but cannot find a solution. Here it goes;

I need a formula that can search through multiple tabs and list the matches.

I.E.
My excel document has 12 tabs, labelled Box 1, Box 2 etc. In each of those tabs, there are columns position (1 to 100) and name. Say i have Harry entered in Box 1 Position 29 and Box 10 Position 51, I need a formula that searches all tabs and lists all Harry's.

Is there a formula like that out there? I dont want to click on each tab indivually and use the CTRL+F function, because that will be too slow, and painful. i havent got a mocked up 'formula' added as i dont even know where to begin. but essentially i want to say in the first tab (PV BOX 1) put a formula anywhere in a free cell, and get the results listed.

Thank you so very much in advance.

**i have attached the data. i just made it up right now, easy to spot with just two tabs, and 10 samples a piece, but image 12 tabs with 100 samples. its a pain. i havent added a formula as i do not know where to bgin.

[teylyn]

Hi manning,

welcome to the forum. However, I'm afraid ...

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

A suggestion for a better title can be found in your second paragraph, i.e. "search multiple tabs and list matches"

[JBeaucaire]

I'd love to see your sample workbook with an example of your desired results mocked up manually. That should make it easy to see what you're doing.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

[shg]

Why not use Ctrl+F, select Workbook instead of Worksheet under options, and press Find All?