Excel Macro to Copy Filtered Data to a New Sheets

Closed
Report
-
Hello,

I am writing an Excel macro that:
1- For every name on a list of values, creates a new sheet using the value from the list (DONE)
2- Filters the data based on the values in the list and copies them in the new sheets previously created (HERE I NEED YOUR HELP)
3- Creates new workbooks for every sheet in the original workbook (DONE)

Can you help me complete point 2?
The list of values would be in a sheet called "LIST", starting from cell A1

Thank you in advance!