VBA Macro to Split Consolidated File into Multiple Files

I am looking for a skilled VBA developer to create a macro that splits a consolidated Excel file into multiple individual files. The macro should meet the following requirements: - Each split file should have a specific name. - All formulas and formatting from the original file must remain intact in the split files. - Each split file should replicate two tabs from the consolidated file. - After splitting, recent rows and columns in each individual file need to be locked.