Changing a Reference that uses Quote Marks - How ?

[stucamps]

How do I change the below formula to seperate into two parts:

='[Active Money.XLS]Dec-04'!$F$10

change to

='[Active Money.XLS] & "xxx-xx'!$F$10"

where xxx-xx is to be a reference to a dynamic date driven by the EOMONTH formula and refers to a new worksheet on the Active Money.xls.

I cant seem to get this to work as there are single quotes in the name ??
Thanks
Stuart

 

[Oaktree]

Maybe:

=indirect("'[Active Money.XLS] "& text(today(),"mmm-dd")&"'!$F$10")