I understand, however for this application it will be pasting in the last cell selected on the previous sheet. (Sometimes it will be pasting to education, other times to work, activities, or interest).

So this way whatever the last cell was selected when the sheet is selected again the desired cell is already selected.

I am curious to know how to assign the sheet name from f4 back to the 'ws' variable, so this admittedly ambiguous process can be used on multiple sheets and fields. It doesn't seem to hard but I can't figure it out. I tried this:

Dim ws As Worksheet

Set ws = Worksheets("Multiple paste Values").Range("F4").Value