Search box which finds all instances of input keyword, copies and pastes into one sheet

Hi guys,

In a workbook with 100+ sheets which are hidden, I want to create a 'search box' in 'F&F' which will find whatever is input and copy the row of all instances to generate a report on a new sheet.

Additionally I would like to create a button in 'F&F' which generates a 'Total' report which copies all data from all other sheets and adds instances of duplicates to form a total. E.G if Sheet 3 contains 'MILK' in A1 and '15' in B1 and Sheet 4 contains 'MILK' in A5 and '5' in B5, the new, total sheet will show 'MILK' and '20' in separate cells.

Cheers!

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Your results in Sheet "F&F" are no-where on sheet "Freezer 4", where do those strings come from?

Never mind, I get what you are trying to do.

There is no consistency in your ranges.