Automation Tips?

I have a multiple spreadsheet workbook that covers a 2 year time span. Spreadsheets include monthly data of Payroll, Quotas, Expenses, and a Summary of year 1 and year 2. I don't need help with it, but interested in what kind of automation others use. I tried to search for general tips, but unless the search was very specific, the results tended to be businesses trying to sell services or simple things like pivot tables.

What I use:

• Dynamic named ranges using the Offset function for dropdown lists of positions, quota types, expense types (eg monthly, annual), and a site list.
• These selections above autopopulate other cells using Index Match for salary, quota, revenue, and expense data.
• I have monthly workdays listed that remove holidays based on a cell with the start date using several functions: Networkdays, Eomonth, Date, Weekday, and Choose. These are used in several calculations and now update from a single cell's date update.
• Year 2 is dependent on year 1 inputs so it should require few adjustments.
• Everything rolls up into the summary worksheet that shouldn't need to be touched.

Now that I've typed it out, it doesn't seem like a lot, but it's made my spreadsheets much less manual. If anyone knows of a place to read more about things like this I'd be interested. What kind of things do you use?

Thanks CAntosh. Your example is more what I was looking for. I don't need help with my file, but spoke of it as an example of what I've done. I'm more interested in what others do so I can learn more. Whether it's useful to me or not, knowing it exists and is possible is a benefit.

That's really cool! Thanks a lot!