I created a macro that imports production results from multiple staff folders. Before I had the macro I was manually coping and pasting their results into staff tabs that was auto filling a PivotTable. When I clear the data that was imported the links to the other tabs are lost, they give me the...