|I'm not sure what you are trying to do since the contents of your post doesn't seem to have anything to do with your subject line.|
I'll try this:
You can use sheet names in formulas.
If you have a sheet named Bob Smith, you can use:
='Bob Smith'!A1 or =SUM('Bob Smith'!A1:A6)
If that's not what you are looking for you'll need to provide some more details.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.