I get vba at a basic level and am trying to move to more advanced topics. Would appreciate any guidance on here or link to useful material.

This is what i want to do

i have already created a macro (macro1) that creates a spreadsheet based on an input cell (a date) on sheet1 (cell C1).
in sheet2 i have a list of dates in column B
I want C1 on sheet 1 to run through the list in sheet 2, and each time run macro1, copy the information in sheet 1 (from row 4 and below) onto a new workbook that is created.
Create 1 folder and Save all the workbooks that are created in that folder.

The names for the folder and the for each of the files will be located in cells F1 and G1

videos, links or actual code itself would be great.

Thanks!