I know that we can append several tabs together and come up with a consolidated query. What if the other way around I will get a Data and I will need to split each project listed in this Data into several tabs?

I was thinking to manually filter the project in a Query, then copy the script and do it for another query by changing the project number.

I also thought to perhaps using a parameter query but in this case I do not want a drop down list of projects. If I put them all in one table then I will have to change a parameter query for each record as "{0}[Column1], "{1}[Column1] etc so there will be parameter queries for each project number (same as if I would just create extra queries with project filtered for each).

Or would the VBA be better in this case, not sure what option and what VBA might be useful here.

Any advice is appreciated