Import File Name With Out Full Path Into Header

Hi All!

So here is a challenging one that has had me going for a solid week and I can't seem to wrap my mind around it.

So what I have is a simple spreed sheet with a macro, I click import to active a pop of file directory, to select file to import. That seems to all go fine but what I am struggling with is I need to import the name of the file as well into my header. Can this be done or is it pretty much hopeless.

This is for my job site where we do trailer inspections, and I was hoping to cut the time we spend copying and pasting this information. I have attached my excel with macro (Trailer Inspections) and a mach up (YardHoundReport) of what the sheets look like that I am importing.

Also if you know of a way to insert blacked out rows between the different parking areas that be sweet too, but it's no biggy.

Thank You for any feedback you can give.