Trying to create an index sheet with CommandButtons or Hyperlinks

[Greenhydrolisk]

I've got a workbook which contains multiple sheets of data. A new sheet can already be created using a macro, but I want the last part of that procedure to involve placing a CommandButton or hyperlink on the Dashboard sheet which links back to the sheet.

I need some code which adds a CommandButton to the Dashboard sheet, names and captions it based on VBA variables and then assigns code to the click event of that button which selects the original sheet. Really struggling so any help would be gratefully received!