Worksheet picking function ?

Good morning

I have 7 different work sheets all containing various information. I was wondering is there a way I can set up and IF function that will pick between the worksheets if the condition is met ?

Basically I want to consolidate all the information into one master worksheet and then create a pivot table from all the sheets, does any one know how to do this ?

Above is and example worksheet basically I need to create a master list of all the categories and then make a pivot table out of it, is there an easier way to do it than just manually copying and pasting the data over ?


Thanks

Yes but an example workbook would be useful