@zaki4u
I think you'd help us help you if you:
- added a fair amount of transactional data under the "data" tab (assuming that it is the source of data for filling in those reports you want filled)
- disabling (or disconnecting for the time being) any reliance on external data sources...I certainly don't want to have to be directed elsewhere; I can't speak for others here in the techcommunity in that regard, but I suspect I'm not alone.
- let us know what version of Excel you're working with. It would be very helpful if you have the most recent, and/or a subscription to Office 365, because it has some functions that could be very useful to you.
So far as your own design process is concerned: my advice would be to concentrate on the functional issues first; get to colors and font formatting later...at this stage, too much energy put into prettification can actually get in the way of functionality.