Hi,
I am setting up a worksheet, where I would like to show different questions have been asked by different advisors on a weekly basis. I have a different worksheet which has this data stored as raw data, but ideally i would like the user to click on a name and it show that individuals questions on a new spreadsheet. The raw data would be updated on a weekly basis, so would there be any way that this could be automatically updated.
I hope this makes sense i'm quite new to excel, and have spent the last week searching for the answer to this, and now im at a total loss lol.

Thanks
Slice