Applying named ranges to Pivot table

Hello,

I have a range of data that is added to constently. I named the range "Download" and defined it as =Indirect(Sheet1!B3) where Sheet1!B3 has another formula which produces the range of the data. I want to apply the named range to a pivot table so that when it updates, the range is updated as well but i'm not sure on how to do this. I put the word "download" in the range input of the pivot table wizard but it results in an error and doesn't complete. how can i set the pivot table's range to the named range that I defined?

All help is greatly appreciated

here it is and heres what im trying to do...

on the sheet(com.jdedwards.jas!) theres a list of data. it is downloaded monthly which means its range changes everytime I use this workbook.

Sheet(CONVERTER) has the pivot table but right now the range is set on the range of the current data in sheet(com.jdedwards.jas).

I named a range called DOWNLOAD which is a dynamic range,(the offset formula you gave me earlier), and another called DOWNLOAD2 which is my orriginal INDIRECT Function approach...

I don't really care which one is used at the moment as long as when I update the sheet(com.jdedwards.jas) that the pivot table's source range updates automatically...

Note I am using Excel 2003 not 07 and don't mind the macros... there still in the works..

Could you briefly explain whta I am doing wrong when you do figure it out...

Thanks a million