I want to copy all of the data on sheet1 to sheet 6 to one combined list of data on another worksheet which will always be overwritten when the example spreadsheet is saved.

Example > http://www.sendspace.com/file/igj2zr