Mapping Data to Different Spreadsheets

[Knilsen]

Hi all,
I am needing to map information from my first tab to the rest of the tabs when I choose a specific criteria from column A. In the attached column A if I choose submitted I need that information to go to the submitted tab. I have it to where I can get information to the tab but it is only pulling the first row of my data and not pulling any of the below rows unless the criteria is the same for all the rows which it will not be the correct information. Can someone help me fix the formula to pull the correct row to the correct tab?

Thank you,
Katie