Need to sort thousands of pages to create a list of people from one place.

Hello,

Thank you for taking the time to help me, I am quite new to Excel's VBA so I really appreciate the help.

In the frame of my job, I have received a list of all resistant in France in 1944 and I need to isolate those born in town I work for, in order to pay them homage.

I have tens of thousands of entry, they are sorted alphabetically but because it was given to me in a pdf form, I had to use "I love pdf" to make it a usable sheet. Therefore, it is split in at least dozens of sheet in a workbook and I can't sort them manually. I was thinking of using the .Autofilter but I also need it to copy and past the filtred thing in a seperate sheet (doesn't need to be in a different workbook), bellow what was previously sorted.

Please find attached what it looks like.

Can you help me with that ?

Thank you very much!
Best Wishes,
Nicolas.