Dynamic Input Multiple tabs from a workbook

[stevenlsj789]

I have 50+ tabs with similar layout in one excel file but I only want to import certain columns from each tab and union them all together. Is there a dynamic way of importing? 

[christine_assaad]

Hello @stevenlsj789 

Do you need to pull same column(s) from every sheet or this could vary?

If they are the same, you can use something similar to below where you can import sheet names, let the Dynamic input go thru them, stack the data and give you the option thru "Select" to only keep the columns you need

Hope this helps. Cheers!