Having trouble customizing this macro..

[cstahlhut]

Hi all,

I'm trying to customise this macro I found on the forum so that it outputs differently but I'm a little lost on how to modify it

So the first file before the macro is run is how the data looks. The second file is after I run the macro with two, with the spreadsheets inside the one with "Search Results" is how it comes out after the macro and the fixed version is how I want it to come out.

Basically to only list headers for each section it finds something in and to format them in the way I have. I want to be able to run this search also in such a way that if search results sheet exists already, it deletes and replaces it, can anyone help please?

Thanks,
Cheyne

Online Sample After Macro.xlsm
Online Sample Before Macro.xlsm