Duplicating a table to sort/filter data different ways

[JStirfry]

Hello. I'm looking for a way to duplicate a 'master' Excel table so I can have the exact same table copied multiple times, side-by-side, but with each table sorted and/or filtered slightly differently. The idea is that only the 'master' table be edited and the other tables feed off of it and update automatically.

Any help is greatly appreciated!

 

[oldbrewer]

copy the table to 10 more sheets then use a pivot table on each sheet - should you amend the master then copying it again would take seconds...........