I have already completed a very similar task previously in which several spreadsheets were opened, dynamically searched, and data was imported, sorted, and manipulated in other ways. I know that I can quickly and correctly complete this task.
I can do this by using the built in functions of Excel to open up workbooks, assigning the data to arrays and enter them into the original Excel file for better performance, or, if formatting is important, using the copy/paste methods built into the original Excel file.
Please contact me if you have any questions.