inserting a timestamp on the data sheet when a raw data file is imported

Hello,
I have a workbook that requires refreshed source data each day. The workbook has all of the macros and formulas that analyze the data. I have the following code to import the worksheet with the raw data (onto a fresh worksheet in the calculation workbook), but I would like to create code that also adds the date and time to the imported data worksheet -- not the date/time the raw data was created; instead, when it was imported into my calculation workbook. Thank you for any thoughts you may have.

Below is my code for importing the raw data worksheet:

Please Login or Register  to view this content.

Amazingly simple and effective code. Thank you, buran!