It's usually a good idea to surround the worksheet with apostrophes--if they're
not needed, then there won't be any harm.

And if they are needed, you have them:

=indirect("'" & a1 & "'!a1")



da77 wrote:

I have a Workbook with monthly worksheets (tabs) (i.e. JAN, FEB, MAR..., DEC)

On another sheet, I will have a cell referencing which month I will generate
a report for.

Using that cell, without using nested if statements, can I have Excel
reference data in that spciific month's tab for my formulas in the report?

I may not be clear in the ablve, please let me know if I need to clarify.

Thanks!

--

Dave Peterson