I'm not really good with explaining but will try my best.
I'm trying to use one document to populate 6 other documents, which will populate the different sheets in the 6. I haven't started building them yet, but would want it to fill the row underneath the previous.
Eventually would like to compare the data from the sheets as well but for now I would just like to develop something that works.
You can achieve your requirements by using the Filter function. On the each of the Sheet, Filter(A1:D100, “column of the documents name” = “name of doc1”). Repeat for each document, whether in the same or different workbooks. Hope this helps, or at least points you in the right direction.