Trying to use Vlookup with multiple colums

So you want to capture a snapshot of certain columns on a particular day and save it to another sheet, like your Sheet1 copies.

You have posted in Excel General, suggesting that you want to use formulas, although depending on what you want you may need macros.

You want to capture date on or before a certain date. So each time you grab the data you will have more and more data. Is that what you had in mind?

There is probably a way to do this with formulas if you put the date of interest (rather than "today's date" on each sheet. Right now you just have text typed into a page header, rather than having an actual date appearing as data on the sheet. It could also be done with macros, using the date that the macro is run.