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...