What data your question uses

Active sheet

the tab you have open (default)

Selected range

only the cells you picked

All tabs

every tab in the spreadsheet

Two ways to use itWhat you get back