<a wrote in message ...
I am trying to automate the whole process so that
at the press of a button, the data processing and analysis can be done .

But you are referencing a sheet in the same workbook, so when you open the
workbook, the VLOOKUP will automatically update! So I ask again, am I
missing something? Why the VBA?