My problem is:

Administration make orders in main sheet, create invoice in second sheet and got the product pick list in their third sheet.

Now, 3'rd sheet will be transfered to the Warehouse, as its own workbook for picking products, not to let them mess up anything else.

As changes is made by items going out, this should be reported instantly back to the main workbook, but also changes from the main workbook's third sheet should appear into the warehouse workbook, even as they're picking/scanning out goods on their open workbook.

How on Earth do we solve this demand..??

All great suggestions is very, very welcome! :o)