What I am doing:

I have a workbook that has 26 worksheets, each one namedd from A-Z. Each
worksheet has a formulated list of names with misc. info. I have macros
written to add names and sort the list on each sheet after each entry.

What I want to do:

I want to create one huge merged file of all 26 pages onto one master
worksheet at the end of the same workbook. When I update any sheet on the
list, I want it update the master sheet automatically as well.

Any help with this would be appreciated. Thanks.

Klaus