I have values in a work report that need to essentially get copy & pasted into tblStaging & tblTarget, and allow for the same thereafter. So, e.g., a team “Ravens” and city “Baltimore” from report “Report Type 1” has values in a table on the work report that need to be C&P’d into a table that will then be used as a staging table to paste the now-formatted values into a target table. This has to be done for multiple teams, locations, and report types, so clearing and reusing the stage tables is necessary. The end result should be a target table that houses all the data that is now pivoted from the work report.