VBA to send a worksheet to another workbook?

Hi Excel Pros,

I have some code that I'm using to save a particular workbook's worksheet to a new workbook. It works great but what I'm wanting to know is if it's possible to save an individual sheet from multiple workbooks to a new workbook and have it retain the individual worksheets.

Sub CreateNewWB()
    '~~> Change Sheet1 to the relevant sheet
    '~~> This will create a new workbook with the relevant sheet
    ThisWorkbook.Sheets("Sheet1").Copy

    '~~> Save the new workbook
    ActiveWorkbook.SaveAs "File Path Here", FileFormat:=51
End Sub

Basically, I need to modify this code to run across an individual worksheet in several workbooks and have these individual worksheets each saved to a new sheet in the new designated workbook. Is such a thing even possible?

Thanks!