If you are already doing reporting without VBA I would research PowerPivot, in fact look in to all the new BI features being made available in xl2013.

Suprised though you have not already found the need for VBA, if only to make it easier/quicker to manipulate data and build report framework.