Ron de Bruin has instructions for copying multiple sheets to a master sheet:

http://www.rondebruin.nl/copy2.htm

Ken wrote:
Hi,
I was wondering if you got a solution to your excel issue
within the group. I wish I could help.

For me, I need the VBA code that copies from multiple
sheets to one sheet and was wondering if you could help me
with that, as well as instructions.
I just started with a new company and they want me to fix
a problem they have with some linked excel sheets. They
have 7 different sheets maintained by 7 different people
and there is a Master sheet from where all reports are
generated. But recently, whenever a new record is created
by one of the 7 sheets, the Master sheet loses a record.
Please help, if you could. I am a rookie excel user.
Thanks!


Kenneth
Canada




-----Original Message-----

The data is a list of people, the projects they are

working on, the

completion date, who they work for, their skill set,

etc. My manager

wants this data sorted several different ways ie by skill

set,

completion date and manager.

Several different people will be updating the data and I

don't want to

rely on them to copy and paste it to the additional

worksheets then

sort it properly.

I saw some VBA code on this site that copies from

multiple sheets to

one sheet. How would I copy one sheet to multiple sheets

then sort the

data every time it is changed.


--
cwjohn
----------------------------------------------------------

--------------

cwjohn's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=16049

View this thread:

http://www.excelforum.com/showthread...hreadid=275088

.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html