I found the problem. With the code I will post below, the static date and
time works as iit shoud, however, whenever I use the "data filter auto
filter" from the menu, all cells update to current date and time. Is there
anything I can add to the code that will prevent the date and time from
updating when I use the "datafilterauto filter" feature I am not sure if
it happens when I select the feature that adds the arrows to the top row, or
when I select one of the arrows to sort by.

Thanks in advance