Macro to get/copy data from multiple secondary sheets to main sheet

( Newbie here )

Hello ,

Straight to the ( my ) problem :

* I need a macro that gets / copy ( not cut ) the data from sheet n+1 , n+2 , n+3 ( let's call those sheets : TOM ) and so on into sheet n ( main one = BILL ) .
- I have 3 collumns ( A/B/C) with data in each sheet TOM , that is starting from 2nd row and will have to be copied into BILL also from 2nd row downwards
- every sheet TOM has a different numbers of rows with data all the time ( this happens every time I run another macro ... )
- I want to copy just the values , not the entire formula form cells , if I will implement that sort of thing in the future

* How do I want this macro to be done :
- all the data (values) form sheet TOM 1 , collumn A row 2 to be copied in BILL collumn A row 2 , same thing , separately , with collumn B and C
- then , all the data (values) form sheet TOM 2 , collumn A row 2 to be copied in BILL collumn A row 2 , same thing , separately , with collumn B and C but with the catch : all the data has to be under the data already copied from TOM1
- and so on till I reach TOM n

- Another catch : BILL has to be an exception , I mean the data already in it should not be read and also copied like the data from TOM's ... in it ( hope you get this one )

- And another one : please write the macro divided like this :
-> main stuff
-> text for sheet TOM 1 divided for each collumn ( A/B/C )
-> text for sheet TOM 2 divided for each collumn ( A/B/C )
-> and so on till I reach TOM n ( beacause it has to be easier to replicate code , because I don't know how meny TOM's I will have in the end )
-> obviously ... end of code

I need this macro to work for the " Test Excel.xlsm " that is uploaded here ...

Hope I didn't wondered so far from my problem and I was understood .

Thanks in advance and I wish you all ... all the best in the world !

Cheers !

_________________________________________________

You make our world easier :D to work with !