Creating a Macro Button to Extract Data

Hi All,

Okay i have an Excel Spreadsheet with 3 Sheets inside this. 1) Summary Sheet: is what i would like ALL the data to go to once i press the Macro Button. I'd like it to Capture all the Data from sheets, 2) Sheet1 & 3) Sheet 2. Please refer to the Attached Zip as this explains it in Depth.

Thanks
W