Code for making New columns of Data in a new file (from the data Copied)

Hi,
I have timestamps in column I from cell I2 onward. Dates in column I is in Ascending order. In cell I2, date is 02-Jan. This date continues until cell I10. I want that respective values of Range I2:I10 for date 02-Jan should be copied from columns B and C. Now this code should also generate a new Excel file and paste this copied value in cell A1. Since data copied by code had 2 columns so on pasting on newly created file in cell A1, these two columns will show up covering Column A and B.
Same way after date 02-Jan the next date comes is 03-Jan. this date 03-Jan is in this range I11:I25. So, respective values of this range in column B and C should be copied. This copied data should be pasted in the generated file in cell D1. And so on.

Another Example 27-Jan
Now date 27-Jan covers this range in Column I I41:I53. This date also comes in column S in this range S2:S14. Now this code should copy respective values of Range I41:I53 and S2:S14.
Respective values of Column I should be picked from Column B and C
Respective values of Column S should be picked from Column L and M

This copied data should be pasted in the generated file in cell G1.
Same for other dates coming in column S.

Name of the Excel file Generated by Code:
In dates of Column I and S, month and year is same in all timestamps. So, it should pic month name and year from any cell let’s say I2. In this Case, Name should be in this way January 2022 of the newly generated file.

(As data in columns I and S is already in ascending order, so code should pick first date and go only till it ends and then copy respective values. It should Not Search date value in all cell of Column I and S one by one. In this way it may create load on my CPU. This is a sample file. In actual file I have almost 1 million Rows in column I and 0.8 million Rows in column S)

(Date format copied from source file should be exactly equal to the pasted in the newly generated file)

I have attached the file from which data is to be copied (Named as Source File)
And another file showing Expected Results (Named As January 2022)

I am using Excel 2021

Hi Sir WideBoyDixon,

Thank you so much. It Worked Exactly like what i wanted. Thank you So Much for this code.