vba code - copy tab name to another spreadsheet

[Leonidas75]

Hello

Spreadsheet 1 Name : Weekly Results (tab 1 named : 01/04/2019; tab 2 named : 08/04/2019 etc....)
Spreadsheet 2 Name : Weekly Report (tab name is "Weekly Report")
Spreadsheet 2 tab with Date : Reporting Period ( tab name "Report Period" with Date entered in cell A1)

I have a spreadsheet named "Weekly Results" with a series of tabs based on each week (i.e. 01/04/2019; 08/04/2019....). A second spreadsheet named "Weekly Report" brings across the most active tab (in this instance the current weekly tab) from the "Weekly Results" spreadsheet.

Basically I require code to ask the Weekly Report spreadsheet to open the Weekly Results spreadsheet and using the reporting period specified in cell A1 within the "Weekly Report" spreadsheet to activate the corresponding tab named in the same date format and copy the sheet (not the tab) over to the Weekly Report - Weekly Report tab.

Hope you can help

 

[Leonidas75]

Hello,

Anyone have any ideas to assist?

Kind Regards,