Sheet reference in a formula

Hello,

I'm trying to get VBA to use the sheet reference in a formula instead of the sheet's name.

Here's an example :

Please Login or Register  to view this content.

Now, instead of 'Week August 30' in that reference, I want to use Sheet5 because the name of the sheet will change in the future, making the code look for a non-existant sheet.

Any help with this is very much appreciated.

The formula must use a name but you can set the name per the sheet5 name at run-time:

Please Login or Register  to view this content.