This may help

http://www.rondebruin.nl/copy2.htm
--
HTH,
Barb Reinhardt



"Stolenchan" wrote:

Many thanks, I really appreciate your help - the website is really useful,
although I didn't realise how complicated the process actually would be.

I'm assuming there is no way without using VBA to do this? code is usually
where I fall!

"Barb Reinhardt" wrote:

You could do this with a worksheet_change event tied to each data entry
sheet. Alternatively, you could create a Worksheet_Activate event that
when you chose the summary sheet, it would update from each source sheet.

http://www.cpearson.com/excel/Events.aspx
--
HTH,
Barb Reinhardt



"Stolenchan" wrote:

Okay, this is a bizarre request, but I've been searching around the help
sections and the net, and I'm still not sure if this is possible, or how to
do it, any help is much appreciated.

What I want to do is:

I have eight worksheets in one excel spreadsheet file, one of which is a
main summary page which features information from all other 7 worksheets
(both text information, colour coded and some figures involved... colour
coded rows of information by the same headings).

What I wanted to do was to update the spreadsheet, so that when an
individual opened the spreadsheet and entered a new row of information on,
say, worksheet 3, this would automatically be entered into the main summary
worksheet.

Is this possible, and how?
Any information is great, thanks in advance...