Copy rows based on multiple IFs

I need help with the following problem. I am not sure how the paid subscription works, but I have $50 points credit to pay for a specialist's help.
I am looking to build a sub-routine as part of an automatic scheduling for a medical office. Take a look at the attached workbook.
Sheet1 comes with pre-populated data; the table structure is identical, the table header in row 1 is anonymized. Please keep source table structure the same.
The VBA needs to analyze data in sheet1 row by row starting with row 2 and skip rows that are hidden. In needs to do that in a loop for a specific amount of times as specified in Sheet2 B4 variable that is entered by the user.

The following needs to occur in analyzing Sheet1:
For any unique last name (in D), IF L column contains code D7140 OR D7210 AND IF Column M is between 1 to 8, OR between 9 to 16, or between 17 to 24 or between 25 to 32, THEN COPY row only once to sheet 2 as done manually (shown in red)

Repeat this loop as many times until the number of rows specified in sheet 2 B4 (variable entered by user) has been copied to Sheet2