How to use Formula in DataValidation List Source

[GregM]

Hi friends,
I need to use a formula in the Source: of my Data Validation to include the Sheetname for my drop down list.
The following formula should work if someone can please show me how to properly QUOTE it. I get very confused trying to put quotes within quotes.

To be clear, the Sheetname that has my data is DataDec2018. The Sheetname I am in currently is Dec2018.

OFFSET(DataDec2018!$I$2,,,DataDec2018!$F$3) <-- This works fine, but I'd have to re-type the month for each different tab.

OFFSET("Data"&RIGHT(CELL("filename"),7)!$I$2,,,"Data"&RIGHT(CELL("filename"),7)!$F$3)

This will allow me to have multiple tabs and use the same formula: DataJan2019, DataFeb2019, etc.

Thanks in advance for any assistance provided.

 

[GregM]

OFFSET("Data"&RIGHT(CELL("filename"),7)!$I$2,,,"Data"&RIGHT(CELL("filename"),7)!$F$3)

Okay, it just needs a little help from our INDIRECT function to make it all text.

OFFSET(INDIRECT("Data"&RIGHT(CELL("filename"),7)&"!$I$2"),,,INDIRECT("Data"&RIGHT(CELL("filename"),7)&"!$F$3"))