If your dashboards are to be updated weekly or monthly, you are better off creating a plug-and-play model (where you simply copy-paste the data and it would automatically update). If it’s a one-time exercise only, you can leave out some automation and do that manually.