This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How would you expect the result to be formatted? If the sheets are different schemas, they won't fit well into one tool.
If some of the sheets are the same schema, you can use a Dynamic Input. Using the data you provided, try the below:
The Input Data pulls in the list of sheets, the Filter removes the Overview sheet from the list as it's a different schema (you could add a second Dynamic Input to pull in that sheet as a different set of data as well), and the Dynamic Input then cycles through the rest of the list and creates one combined dataset. Take a look at the attached and see if it makes sense/fixes your issue.
That does work, i appreciate it. I might play around with it to see what i can do from there. The Big issue is that i am trying to add a Report header to each sheet as well as upload these sheets to a powerpoint.