Reading Data From Excel

I know the basic way of doing this when you have a static set of
spreadsheets but I need to be able to process different spreadsheets
every day. These spreadsheets are sent to us by an outside auditing
firm without named ranges. They have a consistent format. Is there a
way to read a specific set of cells without having a named range? Or
is there a way to name a range with ASP? I am open to any options
here. Going through and creating named ranges is the only thing that
wont work sicnce it would take more work than processing the files by
hand.