Copying a range of cells based on the selection of a drop down choice in another sheet

I have seen this question listed with similar sheets but I cannot get it to work for my workbook.

So this project just became slightly more complex. Same thought process, Chassis 1 Common Cause tab is the main input source. The Chassis 1 Top Ten will be selectable based on the selection of the user. All info should flow over with the drop down choice. I have attached the actual spreadsheet I am using instead of a template.

Complete workbook attached.

Jason

In B2 copied to full range

=IFERROR(INDEX(Main!B$2:B$7,MATCH($A2,Main!$A$2:$A$7,0)),"")

See original post for description

For columns C:H =INDEX('Chassis 1 Common Cause'!C$3:C$12,MATCH($B3,'Chassis 1 Common Cause'!$B$3:$B$12,0))
For columns J:Y =IF($I3="A Crew",INDEX('Chassis 1 Common Cause'!J$3:J$11,MATCH($B3,'Chassis 1 Common Cause'!$B$3:$B$12,0)),INDEX('Chassis 1 Common Cause'!J$4:J$12,MATCH($B2,'Chassis 1 Common Cause'!$B$3:$B$12,0)))
Let us know if you have any questions.

In C3 and copied up to H columns.

Please Login or Register  to view this content.

In J3 and copied up to Y columns.

Please Login or Register  to view this content.