A connection always create a new destination sheet in the spreadsheet where it is created. The connection name becomes the name of the newly created sheet.
Every time you run a connection, you are using updates. Connect and Append use 1 update. Consolidate uses X updates, where X depends on the number of sheets you are consolidating.