I'm creating a spreadsheet with 10 tabs, each one being a different hosptial.
Each section of rows on a sheet will contain various patient information (4
rows per patient)

For when patients transfer from one hospital to another, I'm going to have
hyperlinks so the user can highlight the information on one section of rows,
of let's say Southside Hospital, click on the hyperlink, and have the
information cut from that section (deleting those rows) and pasting into the
next available section in the receiving hosptial, let's say Northside
Hospital.

I'm recording other macros on each sheet for other purposes, but I don't
know how to get it that the information won't be pasted over existing
information on another patient.

Thanks