I have a large File that I need to summarize.

On the Summarize tab I need to pull data from other tabs "2007-01", 2007-02,
etc...

There are several fields on each tab that I need to lookup and enter into
"Summarize".

Example, "2007-01!E5" and "2007-01!-G5", etc...

How can I use the tab name to repeat and pull data from each tab?

See Below: Invoice # is the source tab name. Inv Date, Fee, Per Diem isn the
data I need to pull from each tab.


BILLING SUMMARY - 2008

Invoice # Inv Date Fee Per Diem Room Other Total

2008-01 1/07/2008 $600.00 $50.00 $126.14 $31.11 $807.25
2008-02 1/14/2008 $600.00 $50.00 $105.57 $- $755.57
2008-03 1/14/2008 $600.00 $50.00 $105.57 $- $755.57

Thanks
--
A MACKENZIE, CMA, MBA