Multiple files with multiple sheets into one file with multiple sheets

I have a number of individual files with unique names with numerous unique tabs containing the same fields. All of these individual files needs to be combined into one file and all of the individual sheets needs to be combined sheet by sheet. For example: Three files with three sheets each combined into one file with each of the three sheets appended from the individual files.

Area-2 - Copy.xlsx

Area-3 - Copy.xlsx

Area-1 - Copy.xlsx

Developer

Output

Common Use Cases

Join

Preparation

Accepted answers

All comments

You can do this using a batch macro:

1- Update the file path

2- Update the sheet name using the dynamic read

3- Update the macro read properties

3- Call the macro

Attached the workflow,

Hope this helps!

Regards

ReadSheets.yxzp

This should work for you.

Hi @TJ2 ,

I've built some tool to do this automatically.

I've attached the tools and an example.

Open the example, simply change the folder and filename in the directory tool and that should load everything for you.

M.

Multi Sheet Import Example.yxzp

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

To clarify, I need the output file to have the data combined as shown: One file with three different tabs appended together

Thanks for a great macro, I was searching around for ages before I found this post!

Quick question though, I've added the file name to the output data, but I can't work out how to add the sheet name, could you help please?

Thanks!

Hello, is there a follow up regarding this please.

I have a similar situation where I have 4 different inputs, and I wish to combine them into one file with 4 different tabs.

I understand the macro should work however is there a way to show the step by step please thanks.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703