Does the Total cell in the imported sheet have something unique about
it- is it *always* in the bottom right cell of the spreadsheet, for
instance? If it was you could write some code for the master
spreadsheet that creates a formula based on that cell. If the cell has
a unique label that's *always* shown in the cell immediately to the
left of the Total cell, you could write code to look for that.