Hello,

I'm really new on Macro and VBA, so I'd appreciate some help or direction towards my issue:

I have a sheet that is supposed to be a Dashboard. This controls follow up of some tasks, like target date. I have visual alarms when a target date approaches the current date, and so on. All this information (Task Name, responsible, subject and target date) are stored in another sheet, Data.
My idea is when the user inserts the information on sheet Data (for example, a new task), this automatically appears on the Dashboard, on the next available cell. I know this can be done by dragging down the fill handle, and it will just fill the formatting as previously. But that doesn't seem reliable to me, because it would depend exclusively of the user to fill the new information on the right cell on sheet Data. If he/she by accident skips the following cell, the result on the Dashboard will be empty. Could someone please advise how this could be done on a Macro? Maybe with a Update Button and then the Dashboard collects all the information on Data sheet and updates itself. Thanks a lot.