Hello all anything thank you for taking the time to help me out here.
I'm trying to help a friend setup an archive which basically filters data into other sheets.

So sheet 1 will contain all the data



Tool type Serial no. Condition bla bla bla
Working / N/G
And on sheet 2,3,4+ there will be a list of all the working or N/G tools

Cheers all again

How about just keeping one sheet and applying filters there? Why do you need duplicate data? It's not advisable.

Otherwise, if you simply must have separate tables, you could insert pivot tables on the other sheets. Unfortunately, if the data change on the master sheet, you will have to manually refresh the pivot tables.

A sample sheet would be more helpful than this...