VBA Code to Copy Dashboard Date Data, Lookup that Date on YTD Data tab, and Paste Value?

Cross-posted at https://www.mrexcel.com/board/thread...value.1251054/

Hello,

In essence, I'm trying to make a macro that reads the data from sheet "Dashboard" that corresponds to a specific date in cell C4 (in this example, focusing on the range of C9:V9), have it lookup that C4 date in column B of "YTD Data" sheet, and if found, Copy/Paste value the contents of the range C9:V9.

I've included a "Goal" sheet to help illustrate what I'm going for, in case my earlier description was not enough.

In the future, my goal is to load this macro to a button and add a "Refresh All" mechanic at the end, but just trying to get the beginning of this macro done first before I add any bells or whistles.

I'm not sure if there's a way to "futureproof" this macro, in case additional Columns are added or other changes?

Thank you for any help provided.

Thanks,
GR