Formula to duplicate cell content from multiple columns on one sheet onto separate sheet

Good morning everyone! I am hoping you can assist with a formula/solution that I am stuck on and am losing the will....

I have a 'pick list' of items on a sheet which has three columns currently: Item, Category and Description.
This list will be long and will need to be updated manually as items are added.

The second sheet is an output table, which will have more than three columns which data is added manually.
Column A is a dropdown and will select an item from the 'Pick List' sheet.

Depending on what Item is selected in Column A, I am looking to copy across the associated data into the associated headers for that item. the data will sit into different columns than they originally were though.

I am trying to make this automated so that out of a potential list of 200 items on the 'Pick List' sheet, I am able to pull across data for selected items on the 'Output'

To put this in context for a use... A restaurant has a list of all its menu items on the 'Pick List', then the 'Output' could be used for the specials of the day to select certain dishes for the day.
Hopefully that makes sense?

I have attached the basic form of the spreadsheet. Can anyone help please?

Thank you

Alan

Output

B2=IFERROR(INDEX('Pick List'!$B$3:$C$100,MATCH(Output!$A2,'Pick List'!$A$3:$A$100,0),MATCH(Output!B$1,Table1[[#Headers],[Category]:[Description]],0)),"")

Copy across and down

Amazing! Thank you so much!

Originally Posted by HansDouwe

Please try in B2 and copy to E2 and copy down:

Formula:

Please Login or Register  to view this content.

Brilliant, I really appreciate your time, help and live example into the attachment! Alan

Originally Posted by Glenn Kennedy

Or dynamic arrays:

=LET(A,Output!A2:A10,B,'Pick List'!A3:A8,C,'Pick List'!B3:B8,BYROW(FILTER(A,A<>""),LAMBDA(x,FILTER(C,(B=x)))))

and

=LET(A,Output!A2:A10,B,'Pick List'!A3:A8,C,'Pick List'!C3:C8,BYROW(FILTER(A,A<>""),LAMBDA(x,FILTER(C,(B=x)))))

Ensure that ALL expected results are deleted first.

Cheers Glenn!! An alternative I will explore and tinker with! You are all absolute legends!!