I have 4 workbooks in seperate folders that I need to combine into one
monthly summary. The workbooks are different but each contain a columns
named, B/L,Amount,Billed. These are the 3 columns I want merged into one
spreadsheet. What would be the best way to do this?

Thanks
KJH