I have an Excel spreadsheet at work that is used to track my hours. However, the sheet given to us only covers one pay period at a time. So I'm trying to make one Excel document with sheets for each pay period. I did this last year as well, but it was very tedious to go through and do 26 sheets for 26 pay periods.

I was wondering if there was a way to auto-populate sheets so that I could get those 26 sheets with a few clicks, as opposed to copying, fixing data, copying, and fixing data.