This. The stuff I am working on is mostly glorified ETL. Some sheets of course are user facing and will have a nice sheet inside the workbook where everything is summed up.

Generally it looks like this:

1. Get data from a central source (data warehouse/other departments)

2. Transform/combine different sources etc. (mostly with pivot tables)

3. output to a sheet

4. add some sort of automation so it runs on its own the next time