Help

Hope somebody can help. Bear with me. I have a folder of 8 worksheets, these sheets have information on them which I need to collate into one separate worksheet in the same folder (Call this the Overview). I have done this in a way that makes sense to me and is relevant but what I need to do now is - Take this Overview which has all 8 sheets of info onto one and put it in another folder of 8 sheets with similar information and I need it to read them and populate the overview with the information in this folder. So basically one sheet in one folder to read 8 sheets in the same folder. I would like to just save as to each folder. Also (Not asking for much) I need to put this into another folder so that when new data is put in it reads it and auto-populates the overview.