Right didn't realise the branch offices don't connect to your central server, therefore mapping remote drives, or using SMS or PC anywhere isn't going to help you damn.

Ok what exactly do you need to extract from the Branch dbs, transaction records, sales, new customers, or something else? Do the branch dbs contain updated info on the same customers or something similar?

How about adding a branch id field to your databases, that would at least avoid over writing data?

Still not quite sure what you are really asking? Do you need to consolidate transaction records, e.g three branches with sales for the same customer???????