I think you want to use the =indirect() function.

You could put the month abbreviation in A1 of that sheet. Then use formulas
like:

=indirect("'" & $a$1 & "'!B99")

to retrieve the value from B99 of the sheet named in A1.

Type the month abreviation into A1 and all the formulas will "adjust" to point
at that worksheet.


JG_HILL wrote:
>
> I have a workbook with multiple sheets. The first sheet contains a report
> that I need to print using data from a specific sheet that changes each
> month. For example, the report for January needs to pull data from the sheet
> named Jan. When it's June the report needs to pull data from the June sheet.
> Since I know the date how can I automate getting data from the correct sheet?

--

Dave Peterson