You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
rhb-
If you do any amount of data work then it's worth trying to get a bit of a handle on Power Query, it's really powerful for data manipulation.
Chandoo has some decent tutorials on it.
https://chandoo.org/wp/power-query-tutorial/
aggi
The IT team at my place was happy with it, but obviously harder to verify without the website existing.
If you google how to combine multiple workbooks you'll get a load of VBA options that are pretty easy.