Inserting data from various tables into 1

[cheeserush]

Hi all! I have 6 or 7 tables I want consolidated into 1 table based on a drop down using a macro (Im super lazy and dont want to keep retyping). Currently I have my drop down of 5 'titles' and they all have an associated table with them. Each table is between 10 and 30 lines. Could anyone help explain what I need to do and what each part would be doing as im pretty new to this stuff. Also id potentially like to add a couple more 'preset' tables in the future so id like to potentially expand it.

Thanks!

 

[My Aswer Is This]

1. Are all these Tables on the same sheet?
2. What is the name of the sheet or sheets
3. What is this Drop down your referring to.
Is this a range on a certain sheet and if so where exactly.
And what is the name of this table where you want all these Tables copied to
See to help we need specific details like this.

 

[cheeserush]

1. Are all these Tables on the same sheet?
2. What is the name of the sheet or sheets
3. What is this Drop down your referring to.
Is this a range on a certain sheet and if so where exactly.
And what is the name of this table where you want all these Tables copied to
See to help we need specific details like this.

As I say fairly new to this so I have a sheet named build up where I have my drop down. The table is below as per colums A-E. I want the item description part to be populated when I select a drop down in H3.

This information I want to be taken from a sheet similar to this one. The title of the sheet is Ref Tables and I essentially need one of those columns to populate the above description based on said input.

This is more my work in progress sheet so its not all finalized but if I can at least see how the macro would need to run in principle I may be able to pick something up and apply it to my actual sheet. Hopefully this helps you to help me!

 

[My Aswer Is This]

Your original post said:
Hi all! I have 6 or 7 tables I want consolidated into 1 table

Now in this post you say:
As I say fairly new to this so I have a sheet named build up where I have my drop down. The table is below as per colums A-E.

So this sounds like a different request.

 

[cheeserush]

Your original post said:
Hi all! I have 6 or 7 tables I want consolidated into 1 table

Now in this post you say:
As I say fairly new to this so I have a sheet named build up where I have my drop down. The table is below as per colums A-E.

So this sounds like a different request.

Ive essentially reduced what I had as 6-7 into 3 key ones as I wasnt sure how I wanted it, i,e the ref table sheet as I thought this would make it a bit easier. To clarify my request is I want any of those 3 off populated columns to fill the item description table based on said drop down. I included a 4th column to show how id intend to expand this outwards if it works the way I hope. Maybe its my wording or lack of terminology. Apology for misunderstanding.