consolidate cell values from same rows of many workbooks to single sheet

[iamrahul]

Hello,

Hope every one of our members are keeping well by His Grace.

I have many workbooks of Type A (16.1400.5.5310.xlsx) from which I want to extract the values of specific cells into a consolidated Sheet having a format as outlined in the attachment" Required format I".
The specified cells (highlighted in yellow) in the Type A workbooks are static as they occur in the same indexing position for all the workbooks I want to extract form. Also, I need to extract the column values highlighted in blue from Rows 308-598 with column headers as per Row 92 in another consolidated Sheet attached as " Required format II" . As I need to import the data from several workbooks, I wish a separator blank column (yellow) in the consolidated sheet " Required format II" between each workbook import with the workbook name in the separator column. i have no experience in VBA
It would be a great help to receive your kind suggestions and possible solution.
Expressing my indebtedness for all the help I have received till date from the forum.

regards

[DavidBowman]

I have attached a solution. Run the macro ImportSheets and open the file you want to import.

[iamrahul]

Awesome Awesome Simply Awesome....Thank you so much Sir
My exclamations aside, please accept my heartfelt gratitude for the immense effort you took to reach out to me in order to code the cells individually for me as per the format where you could have just given an example. Thank you again.
One piece of suggestion i seek:
If i want to extract from multiple workbooks at the same time and list it in your consolidated sheet one after the other, can u please tell me how to.It is not necessary though.
Wish you all the very best of His blessings.

[DavidBowman]

The file is set up that way. You just rerun the macro for each file and it will add the information below the information of the last file. This is because of this code:

Please Login or Register  to view this content.

By choosing the row being pasted to the row 1 below the last entry in the tables you should just be able to keep running the macro once for each file you want to add.

[iamrahul]

Thank you again Sir.
Sorry for my ignorance about VBA coding.
Sir can you suggest some books/tutorials/videos for a complete beginner with no programming language knowledge to learn VBA.
With the very best Regards

[DavidBowman]

In truth, I having been using it so long I haven't kept up with where the good tutorials are.

[iamrahul]

please let me know if you recollect. i have been awespired by your fluency and i want to learn it from scratch.