Designing an Automation System on Excel

I have Sales Data and I need to design a system that can automate incoming sales leads based on location. There are 3 sheets. One with input, one with computation steps and one with output. Could anyone help me with this? How to get started?