Using only 1 sheet won't work. the data that is pasted in sheet one can only be pre-sorted by beginning date. I need this spreadsheet to be as user friendly as possible because I won't be the only one using this. And also the time format that is copied in prevents me from using only 1 sheet. i have to change the time format to something usable. The pre-sorted sheet is created by a different program each time that program is ran. When this program creates the file it creates it using the same file name every time.