pulling data from multiple worksheets

[zloywolf]

Hello!

I'm very new VBA so I could use some help with the following issue:

I want to compile data from multiple worksheets into a pivot table on a new worksheet. In the pivot table, I want to have tabs for "Customer", "Rig Name", "Equipment", "Daily Rate", and "Revenue".
How can I tell Excel to extract this information when it's not always listed in the same location on different worksheets?

I attached the sample worksheets I am working with.
Thank you!

[Teeroy]

Hi zloywolf,

It's a bit unclear from your example what you want to do but I've always copied the information into one location to produce a pivot table. You could easily assemble the data and produce the pivot table by VBA. Try http://msdn.microsoft.com/en-us/library/office/hh243933.aspx for a primer on using pivot tables in VBA.