print report with data from specific worksheet

[JG_HILL]

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]

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