Enhance Excel Workbook Automation or Create Program to replace workbook

I have created a "database" type excel workbook (with 170 tabs, one for each project) that I use to track project updates, due dates and status. I have very limited excel formula knowledge and don't know how to make my spreadsheet tabs do things automatically. I have incorporated pivot tables and hyperlinks but with my limited skills, many of the actions require multiple steps like "copy paste" and I would like to see if someone can either help me make some of the actions "automated" so that this spreadsheet is more efficient or even better, help me develop a program/software that would do the things I am using excel to do. This workbook is exceedingly helpful as is but it takes so much time to keep the data current. I dont know how to find the right developer/freelancer to assist with this project as I do not know what skills my request requires. If you are interested in seeing the workbook to better understand and/or are willing to discuss, I would very much appreciate finding someone who is able to make my dream a reality! :) Thank you in advance for your time.