Need to link/combine 5 worksheets into 1 (inventory nightmare)
I have 5 worksheets of inventory for 5 different depts.
All have only 3 columns - PART NO / DESC / PRICE
Each dept updates their worksheet daily.
How can I link all 5 worksheets into 1 common worksheet with same 3 columns
so I have a total inventory for whole company. Common worksheet should update
itself when any dept. worksheet is updated.
|