Using VBA to automate copy/paste on new Sheet

I have a workbook that includes multiple sheets, unfortunately, the names and number of sheets vary from workbook to workbook. I am trying to set up a macro that:

-selects active sheets
-copies a specific range of cells
-paste that information to a New sheet
-selects next active sheet
-copies text
-paste into the same New sheet
-repeat until all sheets have been copied/pasted into one new sheet for easy filtering

I have the code to copy/paste, but I'm struggling on how to find active sheets and pasting to a new sheet after each copy/paste.

Thanks in Advance for the help

Thanks for looking and helping