linking different workbooks to a Master workbook

[NewExcelUser]

I was hoping that someone can help me with this request?

I have a total of eight(8) workbooks("Training Migration Schedule ELT", "...EBP","...FAS","...INS","...ISP", "...LAB","...legal","...SYS", each workbook have 15 worksheets("Week of..."). I've created a master workbook that contain the 15 worksheets("Week of..."), with a total of 8 groups per worksheet(using the outline feature) representing the 8 workbooks. I need to update the master workbook, but I'm not sure I know how. Also, one of my greatest challenges is when one of the groups add a row to one of the worksheets, this needs to be reflected in the Master workbook, in the appropriate worksheet.

Can someone kindly help me. If more information is needed, please let me know.

Thanks,

 

[fterry]

NewExcelUser,

You can link the workbooks to your master file by selecting a cell and typing:
='Drive:\directory\[File Name]Sheet Name'!Cell

For instance in your master workbook in the first week's sheet in cell A1 you would type:
='[Training Migration Schedule ELT]Week Of xx'!A1

In this way, as the users update the individual sheets your master workbook will be updated when you open it.

As far as the user adding lines, it would depend on where they are adding them. If they are adding data to the bottom of the sheets then you would just need to copy your formula down in the master workbook. But it could be much more complicated than that if you want it to be.

Hope this helps.