Linking worksheets

[cinci]

Hello! My boss asked me to combine some files for him, and I can't figure out how to do it. He has twelve separate scheduling worksheets (all in separate files) and he wants them all to feed into one master schedule. He wants new lines to update automatically when they are entered onto any of the individual files. How can I do this? Thank you! <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[prabby25101981]

Is the format of all worksheets same? If it is, this can be achieved through a simple macro. Does that work for you?

 

[cinci]

They are all the same format, but I don't know how to set up a macro. Do you know of any good tutorials?