Actually, your solution is helpful but
I am still unable to adapt it to my problem.
I will upload a new excel sheet which could be more clear.
Basically, I need a macro that creates an output sheet
and then selects using AutoFilter all the entries in List1
relating to category A and paste that in the output sheet.
Then select all entries in List2 relating to catory A (Autofilter again)
and paste those entries after the first batch of info in sheet output.
Please can you use the autofilter to search for the entries needed in both lists.