Create and rename sheet in vba then link to it

Hi,

I am rather new to VBA
I was wondering if it where possible to make a macro that does the following

Create new sheet
Ask the user to input a name
Rename the sheet that name
insert that name in cell A4
create a reference in two other sheets and hyperlink them to the sheet that was created.

I then want to assign this macro to a button that the user presses to create the new sheet.


If there is anyone that could help with this it would be greatly appreciated