Build a Excel or Access run programs to read in and update supplier pricing

We are a fastener wholesaler in operation for 40 years who require a simple process that will allow us to date a number of excel workbooks with our suppliers pricing information. The updated pricing will allow us to update our ecommerce shop selling prices and also our B2B selling prices. We have approximately six excel workbooks (increasing continually) containing up to fifty individual worksheet that require updating on a monthly basic. We have attached a sample of one of our workbook and also two suppliers excel pricing files for reference. The worksheets all have the supplier information starting at column BP and continuing to column CD. Also attached are two suppliers excel files and their code numbers which we use in the worksheets in the suppliers columns fall under the columns highlighted in RED. The suppliers code number will always be located in either columns BR, BU, BX, CA or CD. The columns for the pricing information updates will always be either BQ, BT, BW, BZ or CC. We are open to have this project developed in either Excel or Access, but it must be of ease to use and also the information we require must be able to be exported in CSV file format.