Create a template with the formatting that you want, then copy and paste special > values from the spreadsheet received into it to get the correct formatting for the data.
Record a macro to do the formatting tasks in a separate workbook. Open this workbook when you receive a spreadsheet and run the macro over the received spreadsheet to do the formatting.
Of course, both of these options assume that the formatting task is the same for each spreadsheet received.
