when you have a multiple excel tabs, you can go for a power query in excel where you can do any type of transformation as per your requirement like append , merge etc.