multiple index and match using multiple workbooks and sheets.

Hello all,
I am trying to match 2 cells and post result of another cell. here is where I am now. I have 100 attribute labels and attribute values in one workbook. Need to extract the matching Item number I lookup and then find and match all attribute labels and values that are relevant to matching items#.

I need to enter a item# in a cell and then get results from 2 other workbooks.

=INDEX('[Item_Builder_Master.xlsx]ALL-Prods'!$A:$FB,MATCH(L2,'[Item_Builder_Master.xlsx]ALL-Prods'!$A:$A,0)*MATCH('Step 1 - Product Type'!C2,'[Item_Builder_Master.xlsx]ALL-Prods'!$BA$3:$FB$3,0),58)

i need to match an Item number in (###) in 'Item_Builder_Master.xlsx' & match an attribute (###) in the ROW of the 1st match then post result of matching attribute result in the column next to the matching attribute label.
The problem I am having is the attributes labels may not always be in the same COL. or have the same attribute label name.

It's best that you had a sample of your situation as well as a few 'desired result' examples so that we can exactly know what is it that you're trying to accomplish.

Also, from my experience, whenever there's a lookup of an external workbook, it is best to use SUMPRODUCT formula instead of INDEX MATCH.

Last but not least, whether it's SUMPRODUCT or INDEX MATCH formula, it's also best to give a limited range (i.e. $A$1:$FB$1000), instead of $A:$AF. Reason being, if you have the whole column referenced, the formula will be very slow.

overall scenario.
I am doing a data migration for a commerce site with 100K items. The items details are seperated into diff workbooks with theonly common key is the ITEM #. I want to palce the item # in a cell and have it fill in the blank cells around it. IE Descr. Attributes, Keyword ETC...
I need to find the items# on workbook (A) and then find the matching attribute labels and values in Workbook (B). the problem. not all attributes and labels are in same columns for all products. IE: Brand name is in column (AA) for item (XXXX) but on items (ZZZZ) brand name will be column (CA).
My logic is to find the Item match first and then look across in that row and match the attribute label and get the value in the next column.

I attached sample files.
hope it helps.

Sorry: In a NEW WORKBOOK. I want to enter the Item# and merge data from Book1 & 2 based on the items number.

workbook 1 is the RAW un organized data.
Workbook 2 is the Attribute labels in the order needed for that particular item#.
i will attach the 3rd destination book with sample data inserted.
--> step4 is where I need to enter item# (Col L).
(Col T) starts the Attribute VALUES from BOOK1 (Col BA/BB)
Step1 is where the attribute LABELS must go. From BOOK2 (Col C)

I already have all the LABELS done in the proper order based on category Product Type in (Step1 COL A)

WORKBOOK3 is the actual UPLOAD file format needed for new migration template.

workbook3 sample