Dynamic sheet data

[Ryles]

Hello wonderful Excel experts!
I need help please, I want to create a spreadsheet with a column with a drop down of team names (Team A, Team B, Team C and so on). I then need to have a different Team sheet that will capture the relevant team information.
So for example Sheet 1 one will be master file, then sheet 2 will be “Team A” and all data on the master file with Team A selected in the drop down column is captured and moved to the corresponding sheet – does this make sense and is this possible?

Many thanks!
Ryles

[FlameRetired]

Hello Ryles. Welcome to the forum.

An uploaded sample workbook with representative data (10-20 rows is usually sufficient) almost always expedites solution.

If you do not know how to upload a workbook directly to this forum:

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.