Auto Generate Notepads along with fixed text and pick values from cells n savd in a folder

Hi,

I am in need of Code which can Auto generate Notepads by taking names from Table1 range("C5:H") and save into a folders taking folder names in range "C" of table1 and by taking corresponding text from other tables (table2 - table7) and finally get saved in given path.
final package should be for each row that has data from cells (B:H), i want one folder to be created for with name by taking value from column B and 6 notepads to be generated by picking Names from column (C:H).
Eg: Folder to be created with name ABCD_DEF and notepads to be created inside it with names (exp_script_ABCD_DEF.txt , act_script_ABCD_DEF.txt , ..,clean_actt_ABCD_DEF.txt) and while note pads getting generated each notepad has to pick up data from corresponding cells in other table in the sheet and a fixed text to be included in all the notepads belongs to each column.
This process to be repeated until end of row data.

Example:
Step 1) Lets start with Table 1 and row 1 with data ("A5") - A folder named (value in cell "B5") to be generated and saved in the specified path
Step 2) 6 Notepads to be Generated with corresponding Names in range ("C5:H5") and before getting saved, each notepad has to pick data from corresponding cell value from all the tables 2 - 7 and also a fixed text to be picked up mentioned in a cell in the sheet2.
In Detail - First a notepad to be generated by picking up corresponding values from all the other tables and the fixed text which is common for all the notepads mentioned in one of the cell and get saved with name in table1 ("C5") in the above created folder and then loop continues until all the notepads get generated for the range ("C5:H5").
Step 3) Step 1 and Step 2 to be repeated for all the used rows ranging from ("A5:H").

Any help in getting this solved in greatly appreciated.

Attached the worksheet for reference.

Thanks,
Kiran