Update external workbooks with changes made in master workbook

I have browsed the forum and could not find an answer to what I was looking for. My company wants me to have a Master Spreadsheet that when changed will update the corresponding areas in in Spreadsheets 1, 2, 3, 4, 5, 6 and so on and so forth (including their tabs). There are about 50 spreadsheets in all. A student helper found some code that she thought may help, but it doesn't work in the way that I need it to(updates all cells and all tabs.) It only updates cell A1 in the spreadsheets, and it automatically opens them all before it does that (which takes about 4 clicks for each spreadsheet by the user.) I would like a code that updates specific ranges of cells and does not need to open all 50 spread sheets to do so. If anyone needs more information please let me know. I tried to be as specific as I could. I'll post the code below, and THANK YOU for any help that anyone could offer.

Please Login or Register  to view this content.
See my post on Ozgrid :http://www.ozgrid.com/forum/showthread.php?t=148438

THANK YOU