Combine sheets from multiple workbooks in folder into one and rename tabs based on cell

Hello,

I have a folder with 50+ workbooks that all have the same sheets (tabs) with the same names, but different data entered into the actual sheet.

I'm looking to create a button that will copy one of the sheets (named FORM) from every single workbook in the active (opened) folder without me having to manually open the files, and copy it into the current active workbook. Finally I would like for it to rename each tab in the master workbook based on the value in cell A10 for each.

Ideally I want to work with active folder versus specific folder location as I want the button to work with various folders - if at all possible.

If anyone has a code to share that I can tweak, that would be of great help!

Worked amazingly well! I can't thank you enough!!