Hello,

What exactly is it that changes about the Excel file?  Is it just the data that changes, or is it the column names, or is it the number of columns? ...

You probably need to use Dynamic SQL.  I've assigned a value to @sortBy for illustrative purposes, but I assume that this value will enter a procedure as a parameter:

Declare @sortBy...