Copy & Past from multiple Sheets

[Joneye]

Is there a macro or VBA for copy and pasting from multiple sheets? All headings and cells are the same.

example, 1 sheet sent to 100 people. All fields the same, looking to collect the data back and put in a master sheet. Is this possible?

NB when copying data will a mastersheet not end of data and start of data each time?

 

[VoG]

These may help

http://msdn.microsoft.com/en-us/library/cc793964.aspx

http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[Joneye]

Again Many thanks