VBA code based on tab

[Leonidas75]

Hello

I have 2 excel spreadsheets where spreadsheet 1 has tab names based on dates as follows:

Tab 1 = 01.11.18
Tab 2 = 02.11.18
Tab 3 = 03.11.18

Spreadsheet 2 (this is the main file) has a data tab and a receipts tab - the receipts tab has a cell reference based on a dynamic date (i.e. cell A1 = 02.11.18)

I am looking for code to basically say use the dynamic date (cell A1 = 02.11.18) in the receipts tab to go into Spreadsheet 1 and select the corresponding tab named 02.11.18 and copy the whole page back into the main file.

The next day the same process but will say use 03.11.18 and go to spreadsheet 1 and select the tab that has the identical name of 03.11.18.

Hope you can help

 

[RCBricker]

so wb1 = workbook 1 ( the one with the tabs 1,2,3)
wb2=workbook with the cell reference

dim wb1 as workbook, wb2 as workbook
dim ws2 as worksheet, ws1 as worksheet, ws as worksheet
dim str2 as string

set wb1=workbooks("your flile name here")
set wb2=workbooks("your other file name here")
set ws2=wb2.worksheets("your worksheet with the cell reference here")
set str2=ws2.cells(1,1)

set ws1=wb1.worksheets(str2)
ws1.select

that should do what you are asking.