Need help pulling data from several worksheets into a summary sheet, but into a new row

This is what I have right now. Each week for our staff meeting I pull together a summary report in excel, with data and graphs. The summary sheet is fed with information from several other sheets that contain pivot tables. Right now I'm manually going through each sheet and copying the numbers I need into the summary sheet. This summary sheet is updated each week, the data isn't replaced (so when I create the graph it shows the history of the year).

Right now it's a very repetitive and time intensive process. I would like to be able to run a macro button that would populate the next blank column from the data in the other sheets and update the graphs. I've tried just recording the macro but it just overwrites the data in the summary sheet rather than adding it to the next blank column. I can't post the file itself due to our corporate policy. Any help or direction to some tutorials would be a big help. Thanks!