Macro to consolidate various sheets in one book

[JORGEMELS]

Hello, I am initiating me into this but can not find syntax and i hope you could help me, i have a workbook with multiple spreadsheets A1, A2, A3, A4, ...... and I have information in each table, i need a macro to select the range of information and consolidate them into another file, ie the macro would say:


Enter the desired range of sheets:


I would input: from A31 to A34


and create a new new workbook called CONSOLIDATED


example:

ejemplo - YouTube

sorry for bad english

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/questi...-hojas-y-consolidarlas-en-un-nuevo-libro.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).