Prompt and copy worksheet to different workbook

[bcolmstead]

Hi All,

I'm trying to use VB to copy a worksheet from one workbook to another.

I want to:
1) Prompt the user for the location of the workbook with the worksheet to be copied (I think I have this part done using GetOpenFilename)
2) Prompt the user to select the correct worksheet within the workbook specified in step 1
3) Automatically copy the entire sheet (or the data within the sheet) to my workbook that contains the macros.

I can't count on the workbook or worksheet names staying the same for steps 1 and 2. In my workbook, I have a sheet that I want it copied to - the name stays the same.

Thanks in advance. I've searched extensively thinking that someone else must have wanted this same thing at some point. I found bits and pieces, but I have been unable to pull it all together.

Ben