I have a download report in *.csv that I want to use MS Excel to convert into
another *.csv every week. The purpose is to prepare transactions for
importing into accounting software as new transactions.

The report download name is made up of a text string that is related to a
User ID such that the report is received as "ReportName<UserID.csv" The
worksheet in the report is the same name as the file name. The report has
the data header on row 3 and the transaction records begin at row 4 to a
variable number of rows.

1) How can that data be read and replaced in a worksheet of a reusable
workbook such that old data of a previous copy paste is removed and fresh
data laid down so formulas can read the new data?
2) How can all references to the report file be mass modified when the
UserID changes?

Thanks a bunch,
Ralph