Any ideas for this extensive calculation?

One table has these 5 columns:
1) Serial Number
2) Ref (a unique number in each table that remains the same in all rows, i.e. each row entry will be '1').
3) Date
4) Qty
5) Order

I have approximately 700 of these tables. I need to carry out calculations in each table individually and have outputs for them. Once my code locates the table, I know how to carry out the calculation but the problem is running a loop to locate these tables. Can someone give me an idea to set the sheet up to run this calculation? The code in my head would look something like this but I have no idea what the syntax would be:

Creating tables:
Loop i from 1 to 700 where table name = table'i' and columns as mentioned above

Calculating:
Loop i from 1 to 700
With table'i'
'calculate

I have attached a sample of what the tables would look like.

Originally Posted by YasserKhalil

Hello
May be this is a simple code

Please Login or Register  to view this content.

Thanks for the idea! This creates the range in the loop. It would work I think but it would be ideal if there was a way to permanently set these ranges so I can address them even outside the code. I want to set these tables because data will constantly be added to it and they will be addressed in several other parts of the code.

I want to name them as Table1, Table2, etc. and then the loop to address Table1, Table2, etc.