Do the others want to update info in the spreadsheets and therefore
update the master (i.e. resynchronise) or do they just want to read a
copy.

If its the latter, then you could use a macro to produce the individual
workbooks by stepping through the Sheets collection and copying them one
by one into new workbooks.

Dim Sheet As Worksheet

Sub Test()
For Each Sheet In Sheets
Workbooks.Add
Sheet.Copy Befo=ActiveWorkbook.Sheets(1)
ActiveWorkbook.SaveAs "C:\" & Sheet.Name & ".xls"
ActiveWorkbook.Close
Next Sheet
End Sub


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560136