You could use workbooks("name.xls").activate. with the name of the original
workbook instead of name.

If the name might change you could capture it before opening the other one
with

pwkbk=ActiveWorkbook.Name

then after the paste use

workbooks(pwkbk).activate

I'll give that a try - thanks !

It didn't work for me - was I supposed to dimension something ? I
was wondering why you have workbooks instead of worksheets - maybe I
didn't explain - I only have one workbook.

Say its called USA.xls - and I have 50 tabs with USA_Summary the
first tab on the left - the second tab is AK, the third is AL the
fourth is AZ, and so on - If I'm on TX , and I copy and paste to
USA_Summary tab, I want to be able to go back  to TX.

Sorry I wasn't more clear.

You said "How do I code  to go to next workbook  or previous  workbook ?" That
is why we were giving you code to do that.

If you want to activate a worksheet  you use

ActiveWorkbook.worksheets("Sheetname").activate

Instead of "Sheetname" you can use a variable which holds a string equal to
the sheet name. You can also use a number representing the position of the
sheet in the workbook but I would only use this if I was cycling through all
the sheets in for loop.

So while you are on the source sheet you could set a variable (say, PWkSheet)
equal to the name of the current worksheet. Then you could use the variable
to activate that sheet.

Sub something()
Dim PWkSheet As String
' other code
PWkSheet = ActiveWorkbook.ActiveSheet.Name
' more code
ActiveWorkbook.Worksheets(PWkSheet).Activate
End Sub

Relying on previous/next is not a good idea, I don't think.

If I need to refer to something again, I just grab a reference to it for
future use.

Set MasterWorkbook = ....

Then I can use without further trouble, regardless of where it is in the
hierarchy.