将值复制并粘贴到目标

I'm copying data from one sheet with yesterday's information to another sheet with a table of historical data. The first sheet is actually a vlookup formula, so I need to only paste the value to the historical table. This is what I wrote, but it's saying that the last line doesn't work. Can anyone help?I'm copying data from one sheet with yesterday'