Excel Spreadsheet

I have a spreadsheet that needs a little tweaking. By little I mean I have 6 issues that I would like resolved. These are not going to be easy. I have tried to google for the answer but I have had no luck. I hope you can help! Problem 1: I need the data from a row in one table to be temporarily linked to another row in another table in another tab. This will be dynamic and the linked row within the table will also vary daily. There are 10 total rows in each table. There are 5 different tables. There are 5 tabs. each tab has a table containing 10 rows. I hope that was clear enough. Problem 2: I have a formula. In one part of the formula there is a cell count of a column minus the first entry of that column. Later in the formula, there is a cell count of a column but will a total cell count. My problem is, I have to update this number every time I add a row to the column in question. I would like, if at all possible, this formula to be dynamic and change without my intervention.