Excel & vb guru needed to create dynamic visual calendar including customer logos and brand logos in excel from weekly promotions/forecast data

Proposed Activity to create dynamic visual calendar in excel from weekly promotions/forecast data. We would like the customer logo inserted into the calendar down the left and also our internal brand logo inserted in the row at the beginning which can be linked to from our sharepoint site. So the vb code to lookup up and insert an image into the correct excel field is required. 1 Use the Grid Set-up list to set-up the rows required for the supplied list of Promotional Activity Refresh the pivot table to start with See structure on Grid set-up tab plus example on Calendar Tab 2 Add a "Summary block" to the calendar for each activity items see style and content on list data tab Use the week number, customer, brand to determine where the block is added onto the calendar Grid note if more than 1 promotion in a month for a customer and brand then they will need to go on separate lines so they don't overlap (this maybe needs something a little more clever as something in week 4 of a month running for 4 weeks may overlap something in the next month. Or we can leave the user to manually adjust for this??) The summary block is made up from a number of fields of data. The block will need to be adjusted for length based on how many weeks the activity run for. I do not have a preference for using pasted text boxes or inserting the test into merged or "centered across" cells. the centred across cells could be useful if they wanted to filter the calendar. when adding a block onto the calendar, add into the top row for the calendar a formula to show for the weeks of the promotion, what the customers week number is. There is a lookup list for this. See attached xlsm file - calendar tab for output