Perhaps, just as a start, try browsing
these 2 posts for some ideas:
a. http://tinyurl.com/5pbhy
b. http://tinyurl.com/573nl

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JdeValk" wrote in message
...
I am creating a mutisheet workbook within Excel. I want to make on of the
sheets within the workbook a cumulative sheet of all the others, a master
data sheet if you will. What I was wonder was if Excel has the capability
of
automatically transferring data from one sheet to another. For instance, I
want to be able to write to sheet "A" (or any other sheet in my workbook)
and
have the value automatically written to sheet "D" (which will be
designated
as the "master". I know I could simply copy the data but I was wondering
if
this is possible.