I have two sheets in my document. The first sheet’s columns are days (A-C) and the rows are specific attributes for each day (temperature, cloud cover, rain, etc). On the second sheet, I have a data validation drop down selector, it’s contents sourced from the “Days” strip (A-C, so it displays A-C as options) in sheet one. When I select day C for example, I want all the attributes for that day to populate in cells down the page. It should update depending on which page is selected. Much appreciated, thank you.

Image: