VBA to link 5 worksheets ?
 

I need to link Col E in 4 of the w/s's to one Summary Sheet Col C . Also
link Col C in the 4 W/s's to Colummns F, G, H, I. in the Summary Sheet, i.e.
W/s #1 Col C to Col F in Summary, W/S #2 col C to Col G in Summary, W/S #3
Col C to Col H in Summary, ect.

Looks to me as VBA is the answer as these sheets (all 5) need to be sorted.

Any help is always appreciated.

Helpless Bob