I want to delete a worksheet when I delete a row in another worksheet (EXCEL 2007)

I want to delete a worksheet when I delete a row in another worksheet
(EXCEL 2007)

In my workbook, I have a worksheet that contains a list of form-names,
with each form-name in a separate row. For each of these rows, there is a
separate worksheet with that form-name containing information about that
form.
I would like to include this functionality:
When the user deletes a row from the first worksheet, the corresponding
worksheet is also deleted.
My initial approach tried using the Worksheet_Change event to trigger code
to capture the form-name from the row deleted, and then to delete the
worksheet with that name, but I cannot capture that data since the row is
already deleted.
Is this functionality possible? Thanks.