Modify code to pull from a different workbook

Hi,

Attached is the macro to combine different workbooks into one. But if you want to pull data from multiple worksheets in one workbook to other, you need to add some code to this macro.

This macro pulls data from Sheet1 of all selected workbooks and merge into one worksheet of macro.

CombineWorkbooks.xls


Regards,
Paresh J

Not exactly what I am looking for, I guess I needed to have explained it better.
I use data from "file A" to fill in for "file b"

I'd like to have a macro that moves data from cells in "file A" into other cells in "file B" selecting the row that holds all the information for the particular file, based column A which is our customer's purchase order numbers (could be any row) in "file A" and K3 which is also customer's purchase order number in "file B"

The information from column B in "file A" needs to go to column L in "file B"; E to T; F to U; O to AA; P to AB

Ideally I would type in the customer's purchase order number in "file B" cell K3, and the other information I need would be filled in from "file A" or could be that I type in the PO # and click a button to bring the data in.

The code I listed above moves from sheet to sheet based on the customer's purchase order #, within the same workbook, but I need it from one workbook to another. I keep running into bugs, and can't figure out my errors.

Thank you for your assistance.