Hi,
As I understand you need Excel which is linked with multiple sheets and you also want to generate sheet with advance Excel formulas. It would help to discuss further on the requirement possibly with some sample sheets.
I am well versed with Excel and its various features like Userforms, Countif, SUMIF, Left, Right, Pivot tables, HLookup, Vlookup,Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards
If need be I can also do automation using VBA/Macros. I have done good amount of work in Excel macro handling. It includes userform creation, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.
I will be happy to answer any queries that you may have.
Looking forward to your response.
Thanks