I am someone who has done complex worksheets using only formula to achieve a desired dynamic sheet. Although I can design one using VB, most of the Excel workbooks I've dealt with end up on a SharePoint server where only formula functionality is preserved.
Before I accept the project, I would need to know the outline of the project, the number of entries, how the data is to be manipulated (if applicable).