Open Excel 2K files & Link Cond Data

I need to dynamically open a secondary Excel 2000 file & link data conditionally to the primary Excel file.

This is the scenario: I need to open an Excel file whose name changes daily (i.e. Reportyyyymmdd.xls-based on current date) and link datain that worksheet. Each row’s data layout (item, cost, qty, etc) are always the same but every row may not always be in the file. So Cell 1 needs to link to the Item A’s cost if Item A exists, Cell 2 links to Item B’s cost if Item B exists, etc.

I know Access VBA, but no experience with Excel VBA. Can anyone help??!! You would be a lifesaver and it would be greatly appreciated. Thanx!