Dear All,
I have 1000s of same structure excel files in a folder.
I want to extract some common details to one single excel file.
Ex. in excel file book1.xls, page a1 relates to name of customer 1, a2 relates to his address, a3 relates his contact number. etc..
As well as in book 2.xls, page...