Linking challenge

[Markshnier]

I'm working on a project to link many separate workbooks to consolidate key figures into an Executive Dashboard.

In one case the source data has a new worksheet in a workbook each month, with sheet names like Jan08 or Feb08 etc. so that would be a showstopper to link to. So, I'm thinking that there could be a formula that I could use where I have have a sheet called Current month, and I would specify the specify the sheet name (e.g. cell a1 contains Jan08), and it would bring back the value of the a cell, say A2 of that Jan08 sheet.

That way I would always be linking to the sheet called Current month.

I have been trying to use the OFFSET function, but trying to specify another sheet is not working for me.

Any ideas out there?

Thx

Mark

[psumvp]

YOu can still create Jan08 within a formula, use:

=TEXT(DATE(2008,ROW(),1),"mmm")&"08"

as you paste it down, it should give you Jan, Feb, Mar...

or if you want to paste it over, change the ROW() to COLUMN()