Select last sheet that had focus

Thank you Shg.

Just one more question.

Now how can I use the sheet name from f4 to go back to that sheet and paste?

the code I use now has the sheet name hard-coded:

Sheets("Data Sheet").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

How do I assign the string from f4 as a worksheet name (so I can return the focus there)?

-BC


P.S. Thank you for your help and patience I am still very much a beginner here.