Help with importing sheet & converting to table

I have a workbook called "Team Numbers" that has pivot tables from the sheets named after a report. The reports are called: "CC Closed This Year", "AR Closed This Year", "Inbox Closed This Year" & at the end of each file has the time the report was ran.

I would like a code for a button that will import those 3 reports on each sheet & then format them as a table so the pivot table is automatically updated. My tables does not have a month column so I added it with the formula

Formula:

=TEXT(MONTH([@Edit])*29, "mmm")

at the end of each table so I can pivot by month as well.

Sorry I had to delete ALOT of info on the reports & one of the pivot tables because the form only allowed me to upload 1000KB at 1 time. You will see the report name & the name of the sheet that should have the corresponding data. If you have any questions please ask, I try to respond immediately as i keep an eye on my email constantly.

I have uploaded all the files including my workbook for any help that you can provide. It would be greatly appreciated! Thank you in advanccredit card