Looping through data and finding cells that meet criteria

I have a worksheet that I wish to separate into separate worksheets by a persons name. I want to copy a row if it meets a certian criteria, D<>"" and paste it into the new worksheet. I can sort Column C wish will contain the persons name, and for every change in column C it will pull the next persons name and create a worksheet with that name and then loop through and if there is no change in column C and if column D <>"" then I want to copy that row into the worksheet. I kind of see what I want, and know what I want, I am just not familiar enough with VBA to understand how to GET what I want. I know there will be a loop and I feel like the more seasoned excellers out there will be able to get this.

Thanks in advance!

Tiger, thanks for the welcome.

I had a tough time going through that and picking out what I would need and what I wouldn't need. Is there a way possible that you could look at this file and tell me what I would need to do to make sheet1 turn into the tabs, by naming them and pulling the information where if it's blank skip and if it's populated, copy that row into the tab named the same as the offset of (0,-1). I think I may have an idea on how to do it with a workaround way, but i'd like an efficient way that will run the calculations clean and quick. This attachment shows the output, but in the code I will include to delete sheet1 but left it here so you can see a starting point. I'm not at that level yet, but hopefully soon after seeing the code and putting the pieces together.

Test.xlsx