Excel spreadsheet automation

Hi, I would like some help with what is hopefully a simple excel project which could grow into a bigger project over time. We are a small company who manages investments on behalf of less than 50 clients. We buy and sell investments (in particular, shares/stocks) on behalf of each of the clients and record these transactions in a single excel spreadsheet. The project is to provide us with the ability to take the transactional data and transform it into a "point in time" report (eg. monthly) for each client so that we can see summary of their investments and other data at that point in time. Some example data is attached. We would like to avoid the use of macros if possible and want something highly flexible where we can add fields, columns, rows, clients, investments and other parameters over time. We are just focused on getting the excel logic right at the start then we can build it from there.