can I take info in rows to another sheet as row headings?
 

I have colum headings project #, discription, location, year, budgeted.
30-40 different projects filled out in the rows.

Can I get excel to take the info on each project, (#, discription, location,
year, budgeted), to another sheet? Such as if I have a template sheet that I
would like the info inserted into, and linked to, so that I have a sheet on
each project in my spreadsheet.

Thanks