Hi, I'm a newbie that needs some help please!

I work in ad sales and need to create calendars in month view that show the client what days they have ads and the cost of that ad/per day. I need an Excel spreadsheet by month that will pull data from the calendar so I can add totals. I am currently creating calendars in Word and then recreating in an Excel spreadsheet. Any suggestions how I can make this more efficient? Thanks!