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