excel spreadsheet data between each other to apply

There is a thin work, the work of the thin 2, 3 ….thin work of various departments of statistical data, assuming the title of A out to customers, down A2, A3, A4 ….for different customers; B heading out for Plan batch downwards B2, B3, B4 ….were a different batch plan; C out for the title of the plan batch downwards B2, B3, B4 ….for the number of different plans, each Thin line of work for each one mapping is not the content, such as the work of a thin D per day is out ….raw data storage, thin 2 D work out ….every day workshop receive raw materials , 3 D thin work out every day ….data storage products, work out thin 4 D ….is shipping products every day, I would like more than a few auto-sector statistics reflect To the work of the thin 5, D as a total storage, E expected to get together as a workshop, F together as a finished product storage, J product shipments as a whole, I do not know if the expression was not clear? Consult expert advice! Thanks!

give you a recommendation, not so many points workbook.
if the amount of data in about 30,000, the proposed You put all the data on a table, and then use the PivotTable, the statistics at any time (automatic) of various data tables, it is convenient.
If there are problems, I sent a message to you, you can make a case Table.I am a / question/74394794.html, may be helpful to you (although those who question the closure of the issue):
Excel workbook can only be applied between the “cell” as the basic unit, such as setting work 5 E thin as a workshop expected to receive only select cell “E2” = thin 2 D work out of the cell “D2” (the same format can be drop-down).
Can not work directly thin thin work 5 = 1.