Build an array of data from three closed workbooks

[YasserKhalil]

Hello everyone
I have three closed workbooks with some data (but the headers are not in the same order for those three closed workbooks)
How can I build an array to store the data in an array of 5 columns ..?
I mean to open the first workbook and store the desired data only .. and then do the same with the other two workbooks
So as to have all the required data into one array
The problem is that the headers are not in the same order and are not in the same title

The required fields are five fields : First Name, Last Name, Email, DBA / Firm / Company, Mobile /Phone/ Business Phone

* Sometimes the files are on filter mode so I need to have all the data not only the filtered data
Thanks advanced for help

Posted at this link too
http://www.eileenslounge.com/viewtopic.php?f=30&t=32049

[YasserKhalil]

I have the following code but need some fixes

Please Login or Register  to view this content.

[YasserKhalil]

This solved the problem but I welcome any suggestions and solutions

Please Login or Register  to view this content.

[YasserKhalil]

Any ideas or suggestions or correction?