in over my head

[Lost]

ok im gonna try to explain this as well as possible. I need help figureing
out how to pull Lot numbers and the amount used of each Lot. The lots are in
cell range workbook1.xls a1:a11, workbook2.xls a1:a11,......workbook6.xls
a1:11 and the amount used is in B1:b11 in all 6 workbooks. Each workbook has
6 sheets in them, so what i need help with is "how do I pull them to
Workorder.xls?"

Example of one sheet in one workbook(same in all workbooks same on all
sheets for data spots)

Wookbook1.xls sheet1 sheet2 ....
sheet6
A B A B
A B
lot used Lot used
Lot used
1 456 20 567 30
456 30
2 345 40 345 20
567 30
3 567 20
345 5
:
11
Workorder
a b c d
1 date1 lot used
2 date2 345 65
3 product # 456 50
4 567 80
5
6
7


I have only 24 places to put the data so i cant have any blank spaces, also
both dates and product #'s have to match between workbook's 1 thru 6 if not
then dont pull data. well say date1 is d5,date2 is d6, product # is d7 on all
the workbooks except workorder.

 

[Roland]

Do you want to do with macros or with formulas?

 

[Lost]

Doesnt matter to me really. as long as it works, this has been beating me
for a week im kinda new to Excel