We have an Excel spreadsheet which is being used to track our
interviewing process for candidate positions.

The spreadsheet contains 11 worksheets. We'd like to be able to
have certain worksheet columns autofill with calculations
(additions/subtractions) into a "Summary" worksheet. In addition, we
are looking to compile what we call a "screening status" of letter
codes from various worksheet columns.

What type of VB code needs to be written to do this sort of thing?
Can it be done? What do you recommend?

We have been advised that the best way to do this is by using
ExcelVBA. I am not a VBA programmer, but am interested in learning
how to do this in Excel.