Write Sheet to text file, comma delimited.

I would like to add a button to the master sheet of my workbook, that when pressed, will write the contents of the data sheet to a text file in comma delimited. I have found several examples of source code for VBA that accomplish text file writing, but I have not found a way to modify them where they function properly.

I have attached a sample worksheet that I need printed (written) to the text file, however, mu main issue is that I cannot make the write function dynamic, where it only writes the rows containing data (including headers). The amount of rows on the data sheet change over time, so I wanted to ensure that the text write code will scan all the rows in the sheet, and writing only those containing data/values/text.