Create a summary list using same fields from multiple sheets

[PaulG]

I have a series of data forms (each identical in format) and want to creat a
summary list on a seperate worksheet drawing the data from the same range of
cells in each individual worksheet

 

[Max]

I have a series of data forms (each identical in format) and want to creat a
summary list on a seperate worksheet drawing the data from the same range of
cells in each individual worksheet

Try this sample from my archives which illustrates a way:
http://savefile.com/files/414328
Interactive Summary.xls
(full details inside ..)