Hi, I'm looking to automate the following task in Excel 2003, by means of a macro?

1. Work down LIST.xls Column A 100 - 150, take adjacent column B code eg "ABCDE"
2. Lookup worksheet named "ABCDE" in Templates.xls
3. Copy entire contents of above worksheet to new worksheet in RESULTS.xls
4. Change cell K6 of new worksheet in RESULTS.xls to be that of column A of LIST.xls eg 100, 101
5. Loop till end of LIST.xls

Any help would be massively appreciated.