Designing an excel document to populate other documents

[JustRuckOver]

Hello,

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.

Any help is appreciated

[#2]

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.