VBA macro to copy between two variables and consolidate sheets

[Majesticangel99]

Hi

I need a macro to copy and paste the data between two variables, starting at “first name” and ending at “last name” to paste to a new sheet. This data is contained in many different sheets so I would need it to be done for all sheets and the data to be consolidated into one sheet in the workbook. (With row pasting directly below the last.)

Thanks