Excel VBA vlookup或另一种获取动态值的方法

I spend the last month making a program that finds specified strings, copies the data underneath it, and builds a Rawdata table from it. Problem is, all it does is copies and pastes, so if the value were to change, the value in the Rawdata table would not. I'm familiar with the =vlookup function but I don't know how to use it in VBA, and I'm not even sure if that's the right function to use in this instance. I spend the last month making a program that fi