Need help with excel assessment tool /data base for farming!

[jspronk]

Greetings Excel Forum!

I am a new time poster/old time excel user. I've used this website many, many times for help and tips with using excel. Thank you for taking the time to help me out

I was wondering if someone could guide me on what I should do for a "Assessment" tool that I need to create for my farm. I'll try my best to summarize what I need:

Since it's not exactly easy to bring laptops onto farms, the current process is to take a "assessment" work paper (Typically asking YES, NO), scan to a pdf, and attach the pdf to an excel document (as a database).

Seeing that we make multiple re-assessments throughout the year, but ask the same questions, here is what was suggested: after the assessment paper worksheet was made, we would then transfer the data to a excel worksheet. Then, after the data is plugged into a worksheet, a "summary" or "database" worksheet will then help evaluate the overall status of the farm. The "summary" worksheet would have to be able to accept new worksheets that are added every time a new assessment is made and brought in.

I have very limited VBA experience but that was what someone recommended to me to add. Others were also web based application so at this point, I'm open to any help I can get.

Thanks again for reading through this and, more importantly the help.

Have a great day!

Jordon Spronk