On Sheet1 I want a macro that searches for the word "Sub" and when it finds it, if the cell directly below it also contains "Sub" then copy one cell below this cell all the way down (in the same column) until it finds either "Home" OR "Time" (whichever comes first). Then paste the data into Sheet2 cell E1.