Code to find first Blank cell in a range of cells and place data from userform field

Hi All

I have a spread with a user input form.
The code so far places creates a new sheet from template and put data to various other forms.

What I am getting stuck on it getting the a piece of code that will find the first blank cell in a range (G18:J27) on the Menu Sheet.
It then needs to place the information from the Class Field from the Userform and then need to create a hyperlink to the new worksheet which has created.

Any help would be appreciated.

Thanks

Tony