Hi All,
I am probably thinking of something quite extreme here, but i will never know if it is possible until i ask

I have a workbook with about 26 sheets on them, which i use to enter codes and other information. Is there a way where i can have a separate sheet in the workbook that will collect all the information from all the sheets which i can then filter to find people who are missing certain codes. Thought this would be easier instead of filtering each sheet

Hopefully this makes sense to you al

and by the way, im not really an expert in excel



If there is a way then i will be grateful for all help

This addin will allow you to merge sheets to a master sheet

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post