Combining a singular tab from multiple workbooks with the same tab name, different schema

Hello - I have 15 files all with around 10 tabs each and I am looking to combine just one of these tabs from each file into one one master file. The tab has the same name but different schemas across the 15 files. How can I do this? I have tried different macros and the dynamic input tool but I am not having any success. Thanks!

Workflow

Macros

Transformation

Batch Macro

Preparation

Data Investigation

Accepted answers

vizAlter

Hi @Inactive User — Try this solution... you just need to write \Example*.xlsx in the end:

Get GL Sheets_v1.yxmd

All comments

vizAlter

Hi @Inactive User — What is the file-format? It's good to attach sample/dummy data to know more about your Input file and desired output file/drawing, both.

unknown

Please see example files zipped. There is this one tab I am interested in (GL Data) and would like to consolidate from across multiple different files in order to analyze and compare the information.

Example Files.zip

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703