Hi royUK,
Thank you for the response, however the macro only deletes the headers in the spreadsheet. Is there any additional information I can provide to clarify?

Thanks again for your help!