Creating Multiple Sheets from data set

This may be fairly simple and I'm over complicating it. I have a form in excel that I want to take a data set table that auto populates the form for each line of the data set. Similar to a mail merge in word where it creates a new different sheet or print out for each data set line.