Merging multiple books into 1

Hello. On a monthly basis a receive ~50 workbooks with the data from various partners. Thankfully, the data arrives in the very same format (same columns apply). I was wondering whether there is a way to avoid 50 copy/pastes into a single workbook and I can write a script or smth that would automatically consolidate files under one table (i.e. will take top row from one of the sheets and then just copy data one after another for easy pivoting).

By: Vladimir

Leave a Reply

Your email address will not be published. Required fields are marked *