I am creating an Excel document where I need to track 8 different types of reports. I have created a main sheet where each column lists an individual report in order of date/time. In each corresponding horizontal column there is a dropdown menu where I can select which of the 8 reports the data is referring to in that column.

I then created 8 additional sheets with each sheet dedicated to one of the 8 report types.

When I select the report type in the pull-down on the main sheet I'm looking for the data entered in that column, for that report, to populate to the sheet corresponding to that report type.

So basically, If I have a pull-down referencing each report type in column A3 and data relevant to that report from B3-F3. How do I get the data entered in B3-F3 to populate to the correct sheet based on the pull-down choice from A3?

I've attached the file as well. Thanks everyone.Reporting Log Help.xlsx