I have a file set up that I am trying to automate to speed up reporting. I have 15 tabs each with a different table, "HR", "Sales" etc. I know how to automate pasting the data from the downloaded master file with all of the data into the tables, but I have to manually delete what was in there before. Is there a way to design a macro to delete all the content in the 15 tables at once while preserving the headers? I created one but it only works in the active sheet. I need it to work in all 15 sheet tabs. Any help on this would be greatly appreciated.