I have to extract some information from a spreadsheet and paste it into another spreadsheet with multiple sheets.

For example, if I have:

Row 1 User Monday Tuesday
Row 7 jack 123/45 876/54
Row12 john 526/4 456/3
Row17 Bob 231/e 314/tw

I have to create a new workbook from above, the new wb should have sheets based on the days of the week, and each sheet should have the heading user, id with the respective users.
For Monday, the sheet will look something like
Row 1 User ID
Row 2 jack 123
Row 3 john 526

The complicated part is that, all user info. is in rows in increments of 5 starting at row 7.
And from the id part, I only need the first three characters as you can see above.

I have the basic code down that can copy the specific row into a new workbook. But I am having trouble using loops.

If anyone can help, I would really appreciate it. Thank you