i have quite a big google sheets file with 15+ spreadsheets.
I need a script that lets me sort some of the spreadsheets with a call of the fucntion/button whatever by a specific column for example:

Spreadsheet “Employees” and “Teams” sort by column 2

(all other data should be sorted like a normal google filter sort)

all scripts i have found only support sort by the active Spreadsheet

thanks in advance

tried to ask chatgpt with no success and google search/search on SO