Create a new worksheet then copy data from mainsheet

Hi All,

Unfortunately, I need help again. Can someone please help me on how to create a macro that will create a new worksheet then copy columns AA:AT in the newly created worksheet.

So far I have a macro that creates a new worksheet based on the day of the month.
The copy codes that I have is not what I am actually looking for because what I need is to copy columns AA:AT to cell B6in the newly created worksheet



Please see attached file.

create new sheet and copy data from old.xlsm