I have a need for searching through worksheets. I am working with Excel 2013. In a past job I had a file that had numerous dated tabs (worksheets) ranging in dates for the full year. I had a script that would each morning would kick off and copy data from a different file and then search through the sheets until it found the next sheet where a specific cell location was empty. It would then paste the copied data into that sheet which would then added data to that cell that was empty. The next day when I ran the script it would then progress to the next sheet in the series. I am now in a new job and have a file that I would like to repeat this process but cannot find a VBA code on the web that does what I had set up previously. I am thinking it was some variation of either a loop or an offset between the sheets. If I could get this process to work I could automate my process reducing the manual effort each day. Would anyone be able to provide any insights. I am an active user of VBA code but do not have the skills to create from scratch. Any help would be much appreciated.