Replacing sheet data regularly to update dashboard
How can I replace large swaths of data in a sheet regularly, and preserve its sheet summary functions so that the dashboard will reflect the new data? Is there a way to import an excel sheet directly into a preexisting sheet? Cut and paste is not an option as there is too much data.
Thank you for any insight or advice you can share!