How to import data without editing hyperlink

Hello,

i have to download data everyday from the net into my excel sheet.

currently i edit the hyper link everyday and then download it.

i want to know if i could download the data without editing the hyperlink


(sorry for security reason i cannot give the web address)

www._________.com/data/input/14sep2009/main.csv

here i have to edit the date everyday and download the data.
i want to know how to:

i type the date in a cell "A1" and the hyperlink automatically takes the date from the cell "A1"
and the data starts to download

thanks in advance