I have spent a lot of time on this problem but cant solve it. I have created
an Excel sheet that covers everything from a tax invoice to a job sheet
There is maybe 10 sections on the form that change with each job - job no,
customer name, date, price, etc. My query is this. Originally I created it
in Excel although maybe I should have created it in Access? Or Word - and
just inserted some database fields? I do need to look back on records of
past jobs.

I also want to use a template with automatically incrementing numbers - with
the folder kept on one computer that all computers network to. (Would Access
be better for that?)

As you can tell I'm no expert - The system I work with now is kind of usable
but I think Im ready to improve it now. I did look into a course in Excel (I
use that a lot anyway) but then thought maybe this was not the program I need
to use for this project.

The other consideration is that I need for others to be able to use it -
these guys have no computer skills so it needs to be as easy as possible
(which is what my current system is lacking..)

I know its a big ask but any advice would be so much appreciated -