Move tab from Workbook1 to Workbook2 using Macro VBA

[nachousa]

I have workbook1 open and I want to move one of its tabs to workbook2.
Workbook1 and workbook2 may vary. I used the "Application.GetOpenFilename" to open workbook1 and now I have
to use it to open workbook2.
This is what I have so far.

Please Login or Register  to view this content.

This is kinda confusing because I dont want to use any specific names since both WB1 and WB2 may vary,
Do you follow?

Any Ideas??

[nachousa]

Is there a function to activate/operate in the Most Recent Opened Workbook?

[royUK]

Try

Please Login or Register  to view this content.

[nachousa]

Hey thanks for that.
It still didn't work though, I got an error at

Please Login or Register  to view this content.

The Error is Script out of Range. I think it is still looking for the DATA tab in the recently open workbook.
thanks for you help.

[nachousa]

Any Ideas why is not working?
I tried editing some but I cannot get it to work.
Hope you can help.
Thanks

[nachousa]

This is my Goal:
Click Button. WB2 will open, data tab from WB1 will move to WB2. that is all. But it is hard since the two Workbooks vary.
Just the fact that I cant use any specific workbook names makes it a lot harder.

Hope you can help.

Thanks