So, it appears the name/date of the sheets has no bearing.

You want the nurse's form data to be imported into your Insert Referral sheet and then parsed into the DATA sheet with the Insert_Record() macro you already have?

Or something else?

Please think this through from start to finish...how/where is the incoming data supposed to land in your sheet, what happens next...and where do we finish up? What about the 3 fields at the top of Sheet2?