Trying to read data from Multiple Tabs

[tandon]

I am trying to read data from multiple tabs (from excel) using Dynamic Input tool however my data is not in specific order i.e. although all tabs has specific columns but it's not in specific order. It means, I can;t use the template hence Dynamic Input tool will not return correct result. Is there way around to read tabs (which are not in order).

[JosephSerpis · Accepted solution]

Hi @tandon try the batch macro approach as suggested in this article.

[tandon]

perfect.