I'm getting an error

Is there a way to keep the header across all worksheet? 

Is there a way to use the third column data to search in and still return the first two columns?

Hey! This is super quick and thanks

Thank you for the above code. I'm just curious. To add a selected range of a specific worksheet too in the body of the email. I have tried using sh.range select method in your code and the email goes out but without the range probably I'm doing something wrong here or missed to add some additional codes.

Really helpful to extract emails in a neat way, thank you!

If you change

If you change
xIndex = InStr(xFileName, ".") + 1

This is amazing. Thank you!

I read the "Protect cell formatting but only allow data entry by protecting worksheet" is wrong. The format can still be changed. I thought you had found something there. You did not...