You would have to use some sort of macro that would upon entry of information on Sheets 2-4 it would put it appropriatly on the summary sheet.

I'm not very good with macros though...

Hope it helps a little...
John