master worksheet
 

I have over 400 sheets that have data on them, i would like to make a master
sheet that would automatically copy data from all sheets and put that
information in alphabical order. I will need to add sheets during the year
and would like that information to load on the master sheet also.

master worksheet
 

Hi tkincaid

See this page for a macro solution
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"tkincaid" wrote in message ...
I have over 400 sheets that have data on them, i would like to make a master
sheet that would automatically copy data from all sheets and put that
information in alphabical order. I will need to add sheets during the year
and would like that information to load on the master sheet also.