VBA list uodating?
 

I have a list of suppliers. Each supplier's name on the list is hyperlinked
to their own page.

Any user can remove a supplier's name from the list as needed.

What I need to happen is for the list to be updated upon completion of the
deleting by removing the blank row left by the deletion.

And upon the completion of the deletion to have that supplier's own page
also deleted from the workbook.

The page with the list and the individual pages for each supplier on the
list are in the same workbook.

Is this possible and if so what code do I need to make it so and where would
I put the code?

Any help would be appreciated.