copy data from several workbooks into one new workbook

[jojo101]

I have several separate workbooks with several different data columns in them. The information that I am interested in from each worksheets is: 1.The date and 2.The Total (Income) for that date.
I want to copy this info onto a separate worksheet. I want the new data to be displayed by date order with Column A displaying the date, column B displaying the income( for that corresponding date) from workbook 1, Column C displaying income from workbook B etc.. Basically I have already constructed individual workbooks for each different source of income. Now I am trying to make an income report displaying each day of work and how much was earnt on that day. I don't know how to use macros or VBA. Hoping there would be a formula that I could use. Any help greatfully appreciated.

[Glenn Kennedy]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic