Oh Wise Ones

HR has a workbook that they add worksheets to and manually name them,
beginning withe either "AC" or "NM" (accident or near miss). I have a sheet
named "Control" that has code to count the number of worksheet by prefix.
Could I have a dynamic range on that sheet that lists the "names" of the
worksheets in a column? And if its not too much more difficult, dynamically
link to the specified sheet?

Mike