Copying data from one workbook to new workbooks and saving them with filenames

Hi arlu1201,

Were you able to create the macro? Your help will help me to save a lot of time as I need to fill such data in excel files (around 2000 excel files daily).

Thanks in advance!