Good morning,
Hopefully this is a simple solution.
I have a workbook with each tab (71 total) containing a business plan for a specific account. The account name is in cell A4 and the planned sales amount is in cell X9. I also have a worksheet in a different workbook with same account names in cells A2 - A72 and want to pull the corresponding sales from the first workbook into cells B2 - B72. Any ideas?

Many thanks in advance.
N