Is there a way to update a column with new information based on new worksheets added without directly referring to the names of the worksheets being added? That way every time I make a new worksheet it automatically updates information based on a column.

Example: I have SKU's in one column and skus from another worksheet that was just added but say I do not know the specific name of that new worksheet and do not want to add that name to the code. Is there a way to do this?