help combining multiple sources for a pivot

i have a few different files that need to be combined into one pivot table but pivot table doesnt allow me to combine the page filter so i end up with 6 name fields and cant combine them the way i want to.( as in Name Or Employee ID(would Form have to be filled with employee ids to do so or what?)).
all im trying to do is have the job sheets tables combined into one pivot table and not have to keep updating it with new code for the tables every time( Job sheet format stays the same except between files(Like Interior Job Workbook(Sheets Named with Job #'s) and Exterior Job Workbook.
Interior - Copy.xlsx
this is the interior file. there is an exterior file as well with tables similar, would just like some guidance or help building the code to compile the data for me from the tables.