Chemical Inventory: Making expired sheet from below

I am trying to extract all expired chemicals from the Inventory Closet, Refrigerator tab, Hood 1 tab, Hood 2 tab, Hood 3 tab, and Hood 4 tab into the ExpiredChemicals tab starting at A5 by combining them. Same format and everything.

Maybe:

Please Login or Register  to view this content.

Is there a way where the list can have no spaces and it only lists the expired ones.

Not sure what you mean. When I run it there are only the ones indicated as "Expired" in Column H.

I made some changes by inserting columns to count my expired chemicals on each tab. I also made a change on the macro for the expired chemicals tab by deleting all the spaces between each tab when it load,so that the list is continous without no spaces. When I press the newly modified macro it copies everything. It copies over the hidden columns. So I see alot of zeros on the bottom the worksheet. Is there a way it only copies the expired chemicals without revealing the hidden columns.

Can you provide the code that you are using?

Chemical inventory.xlsx

Please Login or Register  to view this content.

Its the same code. When I run the code its missing some chemicals that are expired. Its not transferring them into the expired chemicals tab.