Excel VBA Macro loop to run a macro multiple times based on a column from a table

I have built a Macro that does Data conditioning and it runs great!
Now I am trying to automate the input of the data.

Right now I am doing this by going into the Sheet "dataALL," where it has five columns.
Then I filter by column 3 and copy all those into Sheet "data" where there is another table with the same column names 1-5.
Run the macro based on that table, which creates a separate sheet with all the data conditioning, and once done, clear the table.
Then I go back to the "dataALL" sheet, filter the second one of column 3 and repeat for all of them (over 100)

--

I have record it (hard code) for the first two filtered names below below.
I would like to make a loop that does this for all on the filter list.
Not sure how to. PLEASE HELP!
--
Where:
Sheets "dataALL" has the table "DataTable2"
Sheet "data" has the table "DataTable"
The name of the macro to run each time is "AA_MACRO" (Application.Run "'WORKBOOK.xlsm'!AA_MACRO")

Please Login or Register  to view this content.

Thanks! I have some experience with macros but not sure how to implement a loop to this scale, so anything helps! (let me know if anything needs to be clarified)

Try this. What is done with the info on data tab is unclear.

Please Login or Register  to view this content.