Do some data entry

I need you to fill in a spreadsheet with data. I have a excel file which is an address book for my client. It has columns such as Store Number, Address, City, State, Phone Number I want to be able to create new spreadsheets using that address file like a data base So when I create a new spreadsheet. I enter Store Number and it auto populates all their information for that store. So let’s say the address book has 200 stores Now I want to create a new spreadsheet. I am only going to be shipping to 18 of the 200 stores. I want to just quickly enter Store Number. Hit return and it fills all their info in. Enter another and it fills it all in. On the new spreadsheet after it auto populates. I would manually enter in a dollar amount for each store for the total price I am shipping them. After I enter the price for each store on the new spreadsheet. I want the report to show total amount shipping to all the stores I want a report that totals up the amount for each State. So I can see how much Value In goods is going to each state for tax purposes. So would have 50 cells. One for each state. The total of each state would go in the appropriate cell