Don't think that applies here (or at least I don't see it). Let me explain further.
Let's say in worksheet 'Daily' I reference data from worksheet 'Data' which is actually a CSV file. So in my 'Daily' worksheet cell A5 reads... ='Data.csv'!A1 then I copy cell A5 to columns B thru K (row 1). Then I can copy row 1 to 2 thru 100. When done is there a way I can select those cells (A1:K100) and change them all at once to an absolute reference?