My questions is this:

How will I be able to have information pull from one cell in one workbook to
another cell in another workbook? I can easily do it when they are on the
same workbook but different sheets, but how is this possible to have it
automatically pull the information from another workbook into the other
workbook?

example (I know it sounds confusing-sorry)

Workbook 1 (Warehouse 1)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 50 25 =sum(A2:B2) 75

3 30 40 =sum(A3:B3) 70
4 =sum(A2:A3) 80 =sum(B2:B3) 65 =sum(A4:B4) 145

Workbook 1 (Warehouse 2)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 60 50 =(sumA2:B2) 110

3 50 50 =(sumA3:B3) 100
4 =sum(A2:A3) 110 =sum(B2:B3) 100 =sum(A4:B4) 145
Now let' say I wanted to start a new workbook and pull the numbers from both
workbooks C4 into the new work book, how would I make this happen? I can
already do it when the sheets are in the same work book, but I have failed in
trying to pull numbers from certain cells in different worksbooks together.

Can you give me a direct route into completeing this?