Excel Macro to Dynamically Create and Manage Project Frameworks

I need a macro that can create a project framework to the right of the existing project in an Excel sheet called 'Projects.' In column A, we have project names (Project 1, Project 2, etc.). Columns B to F represent suppliers, where column B is Supplier 1, column C is Supplier 2, column D is Supplier 3, column E is Supplier 4, and column F is Supplier 5. There will be checkboxes for each supplier. In column G, we have the number of batches for each project. Each row represents a project. For instance, if I want to create Project 2 and choose suppliers 2 and 3 by selecting the checkboxes in columns D and E, and then I enter the number of batches, let's say 4, the macro should automatically create Project 2 with this characteristics. It should position it with two columns of space to the right of the existing project (in this case, Project 1). The macro should adapt all formulas accordingly.

Additionally, the macro should create a new sheet named 'CFA ABB Finland (2)' for Project 2. The formulas in this sheet should be linked to all of Project 2. There's also a sheet named 'Base models' from which the macro should copy the project framework based on the selected suppliers and batches to the 'ABB Finland' sheet.

Moreover, the macro should adjust formulas in the 'Consolidated CFA' sheet. This sheet essentially consolidates costs from all other project sheets. I need this functionality to work indefinitely, accommodating an increasing number of projects—Project 3, 4, 5, 6, 7, 97, 98, 99, and so on. Please help me; I've been trying to do this for almost a month and simply can't.

If you have any specific questions or need further assistance, feel free to ask.