Hi, I am using Excel on a Mac and am very new to macros. I want to create lists of data from multiple sheets. For example, each sheet has a customer name in A2 and I want another sheet that lists all customer names, and the same with invoice numbers, invoice dates and more.
The sheets are exactly the same format.
Solved by T. W. in 30 mins