Cheers. I found this which, in conjunction with a macro I already had, worked https://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx#ConsolidateDataFromMultipleSheets_CopyAllDatafromMultipleWorksheets (although I imagine it's part of the underlying code for RDBMerge so don't know why that didn't work).
@aggi started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Cheers. I found this which, in conjunction with a macro I already had, worked https://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx#ConsolidateDataFromMultipleSheets_CopyAllDatafromMultipleWorksheets (although I imagine it's part of the underlying code for RDBMerge so don't know why that didn't work).