Can we specify in Power Query which local worksheet to load the data?

Hello   Can we specify in Power Query which local worksheet to load the data? And also to overwrite and delete old rows?   Thanks!