Copy the data from Different tabs on to one tab

[SM]

Hi
Is there a shortcut in excel 2003 to copy the data from different tabs and
paste it on to one tab and making it a master data tab?
Is there a way to select all the tabs of the sheet and making it the rage
for a pivot table and then get the master data pivot table that way? Then it
will be easy to get the master data from that pivot table.

Thanks

 

[Roger Govier]

Hi
No shortcut I'm afraid but Ron de Bruin has written lots of code to do this
type of thing.
Take a look at
http://www.rondebruin.nl/summary.htm