Barb - I managed to get the code to work and copy one of the worksheets
(which I've preceeded to lose and I'm on track to working it out again) but I
couldn't get it to select all of the worksheets and copy from all of them...
maybe just keep attempting with changing parts of the code...
If only I could get back my first attempt at it, that sort of worked!!

Max - this is great but sadly every row is going to be different, although
the top column headings are the same, in your example you use dates for each
doctor, but mine will be representing different companies... unless you have
an example of different rows each time?

"Max" wrote:

Perhaps one way using formulas to frame up an interactive summary
from multiple identically structured source sheets ..

Illustrated in this sample from my archives:
http://savefile.com/files/414328
Interactive Summary.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---