Dear Excel users,

The problem that I have and dont know how to deal with it is the following.

I have a master workbook with all the expenses of my company. This master
workbook has many different worksheets, one for each expense category (one
worksheet for print adv, one worksheet for tv adv, one worksheet for research
costs etc).

I have copied-paste each one of these different worksheets into blank excel
workbooks (so the new workbooks created are as many as the workshhets on the
master workbook) and assigned some people in my company to fill in these
workbooks.

What I want to do is to make the master workbook read the values entered in
the separate workbooks every time I open it and make the updates. If it was
for a few cells only, I could do it manually (click the mouse to a cell in
the master workbook, press = and then click the mouse to the relative cell in
the other workbook and press enter). But here we are talking of big big big
workbooks, thats why I am looking for a way to do it more easilly.

Any ideas? I have to tell you that I dont know VBA, so if you have any ideas
that have to do with macros, please tell me what to do in order to record the
macro.

Thanx a lot
Yiannis