I have am creating a budget spreadsheet and would like to download my bank statement and automatically summarize the amounts by category and date.

I have three tabs on the spreadsheet. Tab 2 includes the bank download which has three columns: date, transaction description and amount. Tab 3 includes the key word (which I selected) from the transaction description (usually the vendor name i.e. Wal-mart) and my assigned category such as Household. Below is a sample:
Wal-mart Household
CVS Pharmacy
Walgreens Pharmacy
Publix Groceries

On Tab one, I want to capture the amounts assigned to each transaction by month.
Category Jan Feb Mar April
Household 10
Pharmacy 5 20
Groceries 50

I am not proficient in VBA. Can a FORMULA be created to search the keyword text in the bank description and based on the category on Tab 3 sum the totals by month?