I have 2 different sheets that I am pulling data from. I need to combine on 1 sheet in chorological order. When this is complete, I need 1 more sheet to have a summary of items that are on the combined sheet, such as date, action, statues, I need to be able to add data to the “All entries” sheet such as if it is closed, opened, in progress, a need to be able to assign a owner as well. I have tried different things, a college suggested I try here to see if any of you could help. I have zero experience with code/script – not sure what the correct terms is.

I cannot use the simple things like v-look up, query has not provided the results I need, I have tried array, but it will not add the 2 sheets together as one in chorological order. Nor can I add data to the all entries sheet that I currently have, .