Excel 2007 : How to automatically populate data

I'd like to create a spreadsheet "Test1.xls" that essentially replicates the functionality of how spreadsheet entitled "Sample.xlsm" pulls the data from one worksheet and represents the data in an orderly manner.

I essentially have a general ledger on "Sheet1" of "Test1.xls" that I need to automatically pull from and spread the data automatically into a final version that looks like "Sheet4" of "Test1.xls".

I know the "Sample.xlsm" uses macros, but I'm new to Excel. I hope the explanation above makes sense.

Any thoughts or sample model on 1 line of "Test1.xls" would be much appreciated! I would then try to tweak the code based on your sample implementation of that 1 line.