I successfully used the example from http:/www.rondebruin.nl.copy2.htm site
to merge 10 worksheets into one Master sheet; however the issue is I have
comments and hyperlinks on the individual sheets. Is is possible for the
comments to come with the data and also have active hyperlinks in the merged
Master document? The desired result will be to use Autofilter on the header
row of the Master document and protect the sheet for use on our Intranet
site. Is this possible? Please advise.

Thanks,