Making fully automated spreadsheet

So I tried to downside and take out details on my current work in progress spreadsheet and I have it attached. Few issues I can't seem to beat. First I want it when I add a new site to the main sheet, it auto adds the site to all the other sheets. Like, we'll add CV302 between CV301 and CV305. What's happening is, CV302 will be added to all the other sheets but the information underneath CV302 will be pertaining to CV305. I need all the corresponding data to stick together. Next, whenever I try to auto fill by dragging a cell to the right, the letters don't fall in line. Example, on the site expense sheet, I pull data from the invoice sheet. The materials figure comes from H10 for CV301 on the invoice sheet and N10 for CV305. I can't auto fill or copy and paste to get excel to understand I need to skip six columns before the next data entry. And again, if I add another site to the main page, I need the invoices pertaining to CV305 to stay with CV305 (move to the right with it). It's pretty much the same senario played out in different ways throughout the book. Would also be nice if when the site progress sheet was updated, it would automatically kick over the most up to date figure onto the main sheet - very minor detail though. I'm not sure why you guys/gals take the time out of your day to help people like me, whether you like a challange or you are just that nice; but I greatly appricate it.