Drop Down Reference to Different Sheet/Cells

Good Evening,

I am working on something for my husband's business. In Sheet 1, I have created a drop down in B1 for Weeks. The drop down references weeks listed out in Sheet 2. I would like the information by the week in sheet 2 to show up in sheet 1 in the proper columns when I select a certain week from the drop down. I have tried a couple of YouTube suggestions, but neither seemed to do what I needed it to. I don't need anything for the Period, Quarter, or YTD columns. Any help is much appreciated! Thank you!