VBA to copy data based on Tab name

[lxondecks]

Hi All,

I have 2 excel workbooks.
Workbook 1 is generated daily and populated with data for the current day. This is a simple workbook containing 2 columns, with Todays date in Cell A1 and the daily data populated within Cells B3:B43.
Workbook 2 is a compilation of the data for the current year.
Workbook 2 as shown below is comprised of 12 tabs, with each tab containing the data for each month.

I would like to know if there would be a way to copy the daily data from WB1 into the relevant Tab and date fields within WB2.

For example for today, I would need the VBA to copy data from WB1 (Cells B3:B43) into WB2 within the "Oct 2020" Tab and Day 28 (Column AC, rows 3:43)
The issue I am having is finding a piece of code that will find and activate the correct tab in WB2 based on the date of the daily data located within WB1

I would appreciate any advice anyone can offer on this.

Thanks

Lee

WB2