Copy Data From Previous Sheet to Next Sheet

I've created a simple workbook to explain what i would like to do. I would like a macro that copies data from sheet1 to sheet2, then the same macro to copy data from sheet2 to sheet3. Not all sheets at once just call the macro from the active sheet to reference the previous sheet. For example, copy the data from sheet1 E6:F7 to sheet2 E22, sheet1E8:F9 to sheet2 E23 and so on. I have been trying to figure this out and just can't seem to get it right, any help would be appreciated! Thanks!

Excel has an option to right-click a sheet and create a copy of it... I know that's not a macro, but it's by far the easiest way to copy a sheet.

Here is an updated file, I would like to call a macro from sheet2 to copy F5:F10 from sheet1 to F14:F19 on sheet2. Then use the same macro only calling it from sheet3 to do the same thing copying the values from sheet2 to sheet 3. Basically, calling the same macro but copying the data from the sheet to the left of the currently open sheet.

Thanks so much that works like a dream!! Sorry about those merged cells in the last update, I should know better than try to do something like this on the weekend with ALL THE INTERUPTIONS I get from the grandkids! I learned a lot from what you did for me Thanks again!