Sleeper: Compare one workbook with multiple workbooks

[Prema]

Hi All,

Here is my problem.

I have a master workbook with all the data in it and will load into the current program.

I need to load multiple workbooks into current(same) program and each workbook contains part of the data from the master workbook.

For example if master workbook contains 10 columns i.e column A, column B, column C, ........column J upto 10 columns.

Then consider first workbook will have column A, column B, column C and second workbook will have column D, column E, column F and so on.

I need to compare these loaded multiple workbooks with master workbook one by one and delete column(s) from every workbook if that column(s) does not exist in master workbook (If second workbook will have column called M and the master workbook does not have this then this M must be deleted from second workbook)

Can anyone give me some clue on below queries:

Is there a way to load multiple workbooks within current program?
How do I perform the above comparison?

Thanks for your usual help.

VBA user