Automating Data feed from Different Workbooks Using VBA

[elieyachoui]

I am a new user of VBA and would appreciate your support.

I have a data set for each of the following workbooks Labor Wages, Capital Expense, and Licensing Expense.

-Each of these Workbooks have several projects (displayed horizontally) identified by the following characteristics: Project ID (sometimes it is written as Proj ID in other workbooks), Year, Month, Cost, Manager, and Cost Department ID (also could be named differently such as CDID).

***Also the the Year, Month, Project ID, Manager, CDID columns are not organized in the same way across the different Workbooks.

-Technically, a Project ID of 345 found in the Labor Wages workbook should also be found in the Capital Expense as well as the Licensing Expense Workbooks, such that all those expenses accumulate to form ONE Total expense for Project ID 345.

Question

Assume that I have the data in those 3 Workbooks (Labor Wages, Capital Expense, and Licensing Expense)

How can I consolidate the Expenses for each of those Projects in a Summary Workbook.
i.e. the VBA should allow me to display 1 project after the other while collecting all the information (from separate Workbooks) in the Summary Workbook.

Result displays those column titles: Project ID, Year, Month, Manager, CDID, Labor Wages, Capital Expense, Licensing Expense, and finally Total Expenses.
....with the data underneath

then Sum the expenses to give Total Expenses

I am really thankful for your help!

Elie