Referencing the TAB in a cell on your worksheet

[exflyer1996]

How do you reference the tab in a cell on your worksheet? The tabs are the names of the month, and there is cell on the worksheet that I want to have updated automatically each month when I make a copy of the worksheet.

Thanks

 

[VoG]

Try

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

 

[exflyer1996]

Worked. Thank you