pulling content from other workbooks into the current one

Below is the code that I have sitting in a totally blank workbook. It calls out to open two other workbooks based on the their date, so that after running there are a total of three workbooks open. The other two workbooks that are called are very similar in content (essentially they are the older and newer versions of each other). These workbooks also have many tabs inside. I need to target the tab in the older workbooker, and the tab in the newer workbook, that correspond to my location, and pull their sheets into the workbook that contains this macro (and will contain more code after I can figure out how to pull the sheets in).

Please Login or Register  to view this content.

I have seen some examples online, but nothing has worked for me yet. Do I need something like:

Please Login or Register  to view this content.

or something to this effect?

Oh, and the name of the tab on both the old version and the new version of the document are the exact same, so I also think I will probably need some kind of macro that can select and rename them individually to something like "Sheet1" and "Sheet2" so that I can destinguish between the two of them. Any guidance would be appreciated.

Thanks

Please Login or Register  to view this content.