Copy only new data from one worksheet to another ignoring blank cells

This is a bit of follow-up to a previous post where I got some awesome responses quickly. I am pretty new at VBA so I am wading into this slowly (or trying to) but so far everyone has been great and it has been very helpful.

We have a workbook that pulls data from a text file into Sheet1. The data always comes in chronologically top to bottom with a time of day in Column K. Sheet2 has formulas that look at columns B and F in Sheet1 and pulls over information based on variables selected in row 1 dropdowns on Sheet2. For example on Sheet2 under columns A&B, Timer 1 and Channel 1 are selected from the dropdown so the formulas in A3 & B3 look over to Sheet1 Row 1 columns B&F and if those are 1/1 it will bring over the data from B&F to A&B. Since the first 1/1 combo appears in Sheet1 in row 3 then the first data to appear on Sheet2 columns A&B are in row 5, and so on for the other choices on Sheet2. The Data tab is simply info that populate the dropdowns.

What we are wanting to do is get the information to look like Sheet3 and then automatically add any new data to the end of the Sheet3 columns whenever Sheet2 is updated. The important thing is that after data is brought over to Sheet3, we may be making edits to it so we do not want it overwritten. Any new data that is brought over to Sheet3 needs to be added to the next blank cell(s) in the respective columns leaving the existing data in Sheet3 in place.

From my previous post I got a perfect answer that works great on data that looks like Sheet1 where all of the columns match up with the same amount of data but it does not work on data that has variable amounts of data in each pair of columns. Any of the other solutions I have found simply overwrite the existing data which is not what we need.

Ideally there is a way to make our Sheet2 look like Sheet3 by putting all those formulas into VBA code and do the updates whenever Sheet1 updates but I thought I would work on things sequentially to get a better understanding of how it all works.

Again, huge thanks so far for everyone?s patience with a slow-ish learner. Any ideas/thought/suggestion would be great.