Help Reqauired for Excel File of BOQ

[USAMA]

Hello Everyone
Hope u all fine.
I have problem in my excel file.
I make Bill of quantities BOQ. For Different areas.In all those areas the items of boq remains the same but the quantity change according to the total amount.and also the number of item change in each boq.It look like a book type .I create a searchable item list but its not working porpperly and formating is not look official type.I have to make the boq 2 times with different formating.second time i also attach the sheet ms word.i want to integrate into excel sheet with same formatting i attached in word file.so when i make 1 time it can automatically make on the excel differnt sheet.