Hello, I am new to Excel Macro so any help would be highly appreciated.
I am using windows 7 excel 2010.
I want to create a macro that would do a vlookup from another WB. From Workbook "Book1.xls" with sheet name "Raw" then paste value only to "Statistics.xls" "sheet3" while lookup value is in cell A1. What I want to accomplish though is paste data on a particular cell as shown in the example below and do the same thing on Sheet4, Sheet5, Sheet 6 up to sheet24. If no ID found in cell A1 on the next sheet then stop process.

From Book1.xls sheet "Raw"
A B C D E
1 ID Name Actual Goal Event
2 2059 Park 50 55 A
3 3216 West 60 65 A
4 4016 Duane 90 95 B


A B C D E
1 2059
2 Park Actual vs Goal
3 50 55 A
4