I have many Excel workbooks in my path C:\ASIA . All the workbooks are structured the same (the extension on my workbooks is .xlsm). In each workbook I have a sheet named "CompanyInformation". I need to capture from CompanyInformtion the contents from each of the following cells.
Cells I9, J10, H11, A12, P14, H18, AND H19
Is there a macro that I can run from Excel that can copy the contents in each of the above cells from each tab named CompanyInformation? The macro would start importing to my current open Excel beginning in cell A1 the contents of cell I9, in cell B2 the contents of cell J10 until you get to cell G which will get the contents of cell H19. The contents of the next workbook would be imported to cell B1 and so on until all the information from all the workbooks is imported.