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.