Creating a Macro Button to Extract Data

Hi All,
Okay Please refer to the attachment as it illustrates it best. 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) Sheet 1
3) Shhet 2
Please refer to att: as this best illustrates it in depth.

Thanks
W

can you put the info from sheets 1 and 2 onto one sheet only, by putting jacks shop, freds shop etc in column A, putting facs flex study etc in col B and reserving columns C onwards for april may june etc data???

shop type april may
jacks shop facs 33 44
jacksshop study 7 6


if so you could have a sumproduct summary sheet on another sheet that would update in real time.