Macro Loop to Extract Specific Values and Min/Max Values From Column/Rows Range

Hi, I'm very new to writing Excel Macro's and wanted to know if I could do the following. Conceptually, I understand what I need done and think it should be fairly straightforward.

There's 2 main events in this loop (I hope that's the correct terminology):

Input 1) User defines the beginning cell to start the loop. In this case, A2.

Input 2) User defines the range of columns/rows to display. The formula for rows that I've thought of is 4r. So if a user wants 20 rows below cells A2, they simply input 5 for r. The number of columns is a constant 5. So if r=5, then I'd want the range to be A2:E22.

Logic)
- Find Value in A2, and Input that value into a new worksheet in cell A2.
- Find Value in B2, and Input that value into a new worskheet in cell B2.
- Find Min(C2:C22), and Input that value into a new worksheet in cell C2.
- Find Max(D2:D22), and Input that value into a new worksheet in cell D2.
- Find Value in E22, and Input that value into a new worksheet in cell E2

Then continue the process except now the beginning Cell Value will be A23, and all extracted values into the new worksheet are input into A3, B3, etc, and this runs to end of values in worksheet 1. That's why I'm thinking this is a loop process.

Hope someone understands and can assist.