Populating a report sheet based on imported values on another sheet

I have sort of a unique problem here, and I'm hoping there's a genius out there who can help me. I've written a database in MS Access, and part of the database exports information to Excel. I have split my workload with a coworker because he is a genius when it comes to Excel, so I left the Excel formatting and programming up to him. However, due to his increased workload, he no longer has time to complete the project, and I know nothing about programming Excel without VBA. His goal was to make the workbook without using any VBA or macros so that we didn't need to buy a certificate to sign the project. I'm not too worried about this, since I'd like to finish this project soon. If there's a way to continue without programming, it would be nice though. Anyway, I've uploaded the workbook so that ya'll can try to understand my problem a little better.

If you look at the workbook, the ERO worksheet is an electronic variation of what Marines call an ERO (pronounced arrow) or Equipment Repair Order. It tracks the maintenance of a piece of gear. If you look at the workbook, the Import worksheet is where my database dumps all of the information, somewhat methodically. The ERO is split into 3 basic sections- the header, the descriptions of work, and the close-out section. My database exports all information pertaining to the header (which should never change after the opening of an ERO) to row 2 with a "header" in row 1 for use by the ERO programmer. All of the information pertinent to the CURRENT description of work is exported to row 4 with a "header" in row 3. All the information pertinent to the close-out section is exported to row 6 with a header in row 5.

Currently, the header section of the ERO works perfectly. He was able to complete all of that. The problem starts with the descriptions of work. When handwritten, an ERO entry would look like this:

(Julian Date) Description of work ----------------------------------------(new defect code)

or simply

(0123) Ordered motherboard on this date from end item manufacturer.--------------------(b56)

The point is that at the beginning of every entry, the technician writes that day's julian date (generated by my database and exported to the Import worksheet), enclosed in parenthesis, and at the end of the entry, hyphens are added to reach to the defect code, to prevent someone from writing anything unwanted in there, and then at the end of the hyphens, justified to the right of the box, would be the new defect code enclosed in parenthesis.

This presents a couple of problems that are well beyond my intelligence. First of all, every time a new entry is made from my database, it overwrites the previous entry in the Import worksheet. I could probably work that out on the db side, if it cannot be solved here.

The next problem, and the biggest one, is the formatting. I've thought of splitting the "Description of work" boxes into three sections: one for julian date, one for description of work, and one for defect. I think this would be my best bet, however, there's still some issues with that. I would want the defect to be placed at the END of the entry, IE if the entry is a paragraph long, I want the defect to be placed to the right of the last line of that paragraph. This seems easy enough if they all remain one cell, however that also causes issues. I could either increase the size of the cell, which would ruin the form itself, or I could shrink the size of the text to fit the cell, which would cause it to be illegible when it is of great length. This is why I think splitting the contents of the cell into as many as needed would be a better idea. But then how do I make sure the defect is aligned with the last cell for the description?

Finally, a problem I will be facing in the future, is the scenario where an ERO becomes more than one page. In practice, on paper EROs, the way we would do it is that some of the same information would be filled out on a second ERO and the description of work would continue on to the second page and then the close-out section would only be filled out when maintenance is done and the gear is ready to be given back to the owner, and would only be filled out on the first page of the ERO.

The way I forsee fixing this problem is that when the description of work is filled, Excel would copy the worksheet and rename the original one to ERO1 or such, and name the new worksheet ERO, so that all of the formatting would be identical, and then the description of work and close-out sections would lose their formulas. I'm not sure.

I can make simple changes to my db, but due to its complex nature and large size, I'd prefer not to rethink the whole task. If someone can help me out with what I have, I'd GREATLY appreciate it. If you have trouble understanding what it is I'm asking, please ask questions.