I'd like to create a formula that always uses the value of a formula which is
located in the last cell in a column for a calculation. Also to mention that
this is also stored in another worksheet.

Entries are made daily so I do not know what the last cell of the column
will be. This would help alot so that I do not have to manually change my
formula daily.