Hi, hope someone can help me here....

I have a number of files in separate sub directories on a network drive.
I have a master file that contains a new section in the range AC10 to BA:20
I need to open each workbook in the range, go the worksheet "staff", copy this range from the "master" workbook into this worksheet and save, then go to the new workbook in the subdirectory in turn and copy this range as described.
Where a workbook didnt have a worksheet called "staff" then it would close without doing anything, this should trap any errors caused by the macro opening a workbook that doesnt actually have a "staff worksheet saved.

If someone can tell me how to do this, all help gratefully received.
Thanks
Lucy, London