need to design macro

In my project I want to design a excel macro with screen that can take inputs . I need the same to take data from background excel file . Giving output as expected based on Inputs on screen and takes the data in background in consideration.