worksheets and workbook

[Jason]

If I have a large sheet with over 4000 rows and a number of columns
including customer name, date, invoice number etc. I'd like to create
duplicates of the sheet which are essentially exact copies of the
sheet but in different orders. In other words I'd like to have say 4
tabs at the bottom with different worksheets so I can have one ordered
by date, one by customer name, invoice etc. I'd like this rather then
re-sorting each time I need to look up by a specific piece of info.
How can I quickly create these add'l sheets? Also, I'm always making
changes and additions to my master sheet is there a way to have 4 or 5
sheets but a change to one will be a change to all? In other words if
I had a customer in the sheet ordered by invoice number, how can I
make sure that change will be in the sheet ordered by sale date also?

 

[Frank Kabel]

Hi
I would use a Filter (Autofilter) for this. all other solutions would
either require (complicated and probably slow) array formulas or a
non-dynamic solution