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

The spreadsheet is quite complex (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 stuff in Excel.