Ok, I have several workbooks with multiple sheets in each.
I have 4 Procedures workbooks for 4 different doctors each work book contains whatever procedures that doctor performs and the totals for each month in that year. In total there are 12 years of data in each workbook for each doctor.
The billing manager does some reports each month in where he compares data for instance he may want to compare Jan 2003 with Jan 1995 numbers or he may want Nov94 and Nov98. I already have a seperate spread for him to do this report where he just copies and paste the data in but, from time to time he has to go into the Procedures spread and change some numbers. Of course these numbers are not updated on the report spread and there is my problem. Is there anyway that he could just enter say Jan03 and have that data pop up in the report spread sheet? rather than have him copy and paste all the time it would be alot better this way whatever data he changes it will automatically come up in the report.

Have you tried Scenarios (Tools Menu)? Not quite sure what all your data looks like, but with scenarios, I believe you can have one cell point to a variety of different links to other cells (one at a time of course) when you give it certain Scenarios. Don't know if this'll help or not?...

Thanks I'll look into it, my workbooks look like this

Procedures Jan-03 Feb-03 Mar-03
Injections 10 5 10
Hospital Visits 25 20 10
Office Visits 15 10 15

I have 12 years of data for 4 different doctors that are like this.