Running a macro to pull from multiple excel sheets

Occasional Visitor

Hello, I am new to Macros, but I am wanting to pull data from different workbooks into a single workbook that I already have set up.  Ultimately, I look at a lot of data and then transfer it over into a single "Master Sheet".  I currently do all of this manually and I know there has to be a simpler/quicker way to do this.  Any help would be greatly appreciated.

1 Reply



this question is very vague and impossible to answer. Yes, you can use VBA for that, but nobody can help you write the code without knowing more about your data structure. And maybe what you want to achieve can even be done without VBA, either with formulas or with Power Query (Get & Transform).


So, post some more info about your data, maybe a sample file. Make sure not to post confidential data. Explain what you would like to achieve.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies