Generate multiple worksheets selected in multiselect listbox. Data is based on a table.

Hi all,

I have here a sample workbook wherein it generates a pdf file (but it doesn't save it yet but when print pdf is ticked, it will save it as a pdf file) as a preview.
When I click the "generate" button, the data in the "Listing Aging" tab will change based on the name selected in the listbox.

What I want to happen is when I select multiple names in the listbox and click generate:

• It will make multiple worksheets on the same workbook.
• The names of the sheets will be the corresponding name in the listbox.
• The data in each worksheets are the data based on their names.

Also, I would like to have a checkbox named Print Excel File wherein if this is ticked/checked, the worksheets that were generated based on the listbox will be saved to multiple excel files based on the file path selected.

I have attached the workbook.

Thank you so much!