Extract sheetname and data from each sheet

[Steve]

All,
Each month I receive a report in Excel format.
The report has a sheet for each day of the month.
Question
How can I copy the sheet name and data from specific cells
For example sheetname = Dashboard - 06.01.08, Dashboard - 06.02.08,
Dashboard - 06.03.08
Starting with the very last sheet in the monthly report
I'd like to copy like this
Copy "06/01/08" to cell a1 in my worksheet
Copy cell b148, e148, g148,i148 to b1,c1,d1,e1 in my worksheet
move down to a2 and copy 06/02/08.

I spent most of yesterday searching past post and found formulas using
"indirect" I couldn't get it to work (I'm using Excel 2003)

Can someone give me some ideas or samples on doing this

Thanks
Steve

 

[Bob Phillips]

A1: enter 06/01/08
B1: enter B148,
C1: enter E148
D1: enter G148
and so on across

A2: =$A$1+ROW()-1
B1: =INDIRECT("'Dashboard - "&TEXT($A2,"mm.dd.yy")&"'!"&B$1)

copy B1 across, and then copy row 2 down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)