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...