Compiling data from 2 sheets using unique id

[bpulford]

I have 3 work sheets within a workbook:

'RawSupplier'
'RawBalance'
'DataForMap'

I need to compile data from 'RawSupplier' and 'RawBalances' onto 'DataForMap'. The Raw sheets contain customer info.

I need all the data from 'RawSupplier' and only one column from 'RawBalances' showing customer balances to be compiled on 'DataForMap' the customers listed are allocated an account ID so I need the balance to be associated with the relevant company. The same company is listed a number of times on the 'RawSupplier' so the balance needs to be associated to each entry.

I have tried things like Vlookup but without success. Also I am not keen on the idea of having to import into access. I will need to do this every day some times twice a day so the more automated the better.

Any advice would be great. Thanks