linking data in various files, each file has 18 worksheets
 

I don't know if I am going to explain this very well.

I have 10 files (each from a different person reporting data to me using a
standardized formI created for them), each file has 19 worksheets (each tab
is named amonth, quarterly, semi-annual, and annual) and each worksheet has 8
data points.

I need to add the data from cell A1, worksheet 1 from all ten files INTO
another file (basically summarizing the result) that will serve as a report.
I know how to do this for a worksheet. To capture all eight point from
everyone's worksheet 1, I have linked the first data point, erased the $'s,
and dragged the cell to copy the formula, which Excel automatically adjusts
for me.

When I move onto the next worksheet/tab, I cut andpaste the formula from the
last worksheet, change the tab name to th next one I want to work on, and
then drag, etc.

Problem is, its a lot of work to do. And to do this 19 times, I have to
click on each file 19 times. Or I have to type the tab name 10 times (to
replace the old tab name inthe old formula). Ugh.

Is there an easier way to do this?