I'm not sure, Mike, but I don't have a suggestion

OP did mention:
Not all of the information copied in worksheet one
needs to be pasted into all of the other worksheets

which makes his issue considerably more complex
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---