Information from multiple worksheets to repeat on a single one

[Steve, Blackpool]

How do i get information from multiple worksheets to repeat and auto-update
on a single worksheet. Basicallly i have a lot of worksheets and i need to
list the information from each of the sheets into a long index list and i
would rather not have to do this manually as several people have access and
therefore would prefer to be able to do it automatically. Cheers

 

[Don Guillett]

Much more detail or
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.