google sheets programming

I need a relatively basic project and data management system set up in Google Sheets. Will be able to explain more once we connect but it needs to include set up of a template (data capture), feed through to a master data source, look up tables and a range of outputs including a calendar view, tables and charts