I am running monthly financials in FRX and creating worksheets into excel.
The starting names are different for each property but the tabs need to have
the same names. Is there anyway to write a macro by placement of tab to name
the tabs in each separate worksheet over and over again each month?

There are 7 tabs in the final worksheet.

Thanks!