open worksheet in a different workbook based on cell name in original workbook

Hello!

So I am creating a dashboard that searches through multiple workbooks for historical data based on an area.
the dashboardworkbook contains an area name in cell F2 which varies based off of what the user wants to do.
based on the dates they want to look at it loops through and pulls up the corresponding dataworkbook for each month.

the datasheets all have a tab names of different areas.
I have already written the code that pulls up each of the different workbooks.


I have defined the name in cell f2 in the data sheet as sitename.



I would like to be able to open a tab in the dataworkbook based off of sitename (I have tried activeworkbook.sitename.select and it didn't work)

is this possible?

Kind regards,

T

Try:

Please Login or Register  to view this content.