We are an insurance broker operating internationally. In our quest to deliver the very best value for our customers we are regularly adding new products and new underwriters to our portfolio. Underwriters require that we report our sales to them using their Excel spreadsheets. These spreadsheets are based on the industry standard Lloyds Bordereaux but they are all different. Typically they have 10 to 20 tabs with 40 to 200 columns per tab. Each tab has different columns. Fortunately we do not have to populate every column of every tab.
We used to populate them by running a report, then copy and paste into the underwriter provided template. It was a tedious process that everyone in the office tried to avoid. Underwriters were constantly chasing us for late bordereaux.