AFAIR, there isn't a specific routine to do that since, given the worksheet is (ostensibly) infinite [sic], how on earth would the routine know where the end is ... and thus when to stop.

It has to be home grown and typically (well, mostly :-) depends on searching down the worksheet to the first row that meets your criteria for an empty row e.g. the first row for which some unique identifier is not set, and appending the new data thereafter.