i cannot emphasise strongly enough, your work will be limited by the capacity of your boss. something they never tell you in school.
i will at some stage be compiling a variety of excel files because my boss is too cheap for a CRM and doesn't understand excel files with multiple sheets or autofilters.
The views he wants have to be emailed to him on separate excel files.