Automate Spreadsheet calculations

I have an excel template that I need some automation magic done to. There are 3 tabs. The first 2 tabs are a company provided spreadsheet that I currently copy and paste from the source to this spreadsheet. The 3rd tab is a summary page from the other 2 tabs. The top half just link back to the 1st and 2nd tabs for specific metrics. I have some conditional formatting to show certain metrics. The bottom half is the part that I need help with. I would like the spreadsheet to fill these fields out automatically. The lists are the same from the above metrics, but they are arranged from best to worst and only the metrics that have been highlighted by the conditional formatting. (This seems a little confusing, but I currently do it by hand and is easy to see if you look at that page) ## Deliverables I have an excel template that I need some automation magic done to. There are 3 tabs. The first 2 tabs are a company provided spreadsheet that I currently copy and paste from the source to this spreadsheet. The 3rd tab is a summary page from the other 2 tabs. The top half just link back to the 1st and 2nd tabs for specific metrics. I have some conditional formatting to show certain metrics. The bottom half is the part that I need help with. I would like the spreadsheet to fill these fields out automatically. The lists are the same from the above metrics, but they are arranged from best to worst and only the metrics that have been highlighted by the conditional formatting. (This seems a little confusing, but I currently do it by hand and is easy to see if you look at that page) 1.) At the very least, I would like the 3rd page to populate the performance lists at the bottom of the page (B29 and below) automatically. It needs to look at how many entries need to be made, I insert new cells for them and populate the cells? Again, just the items that have been highlighted from above, also in order from high to low except for 1 of the metrics. In this 1 metric (Controllable Erosion), lower is better, but all the others will be from the highest to the lowest. If there are no metrics that meet the conditional formatting, the list at the bottom just needs to be left blank. 2.) The second request is to help with the use of this spreadsheet. I currently pull up the D88 spreadsheet, export it to excel, copy the information and paste it into this template spreadsheet. I do the same steps for the 2nd tab. I would like to pull up the first spreadsheet, save it as an excel sheet (D88 11-8) and the same for the second spreadsheet (T1 11-8). Then, on this new created spreadsheet I would browse to the 2 saved spreadsheets and click "go" and it would automatically do all of the previous calculations? I would just like to skip the copy and pasting of the spreadsheets into tabs. The easier the better. 3.) Lastly, After the spreadsheet is done doing it's calculations and everything is complete, I would like a button that will select all of the fields, (A1 thru I75 on this particular sheet), and then copy that to the clipboard. I have to email out this information every day and this again, would save time. I have several saved spreadsheets titled D88 and T1 and the date of those metrics to test. Without seeing the template spreadsheet I currently use, the scope of this work is kind of confusing to describe, but I can assure you it easy to understand?