Auto-populate data from Master sheet into separate tabs

Question

I would like to auto-populate the data from my Master sheet "Open Bookings" based on the customer to a separate tab for that customer. I have tried several formulas and VBA codes, but its not pulling the data. 

I have 15 customers, which means i'm currently having to manually input this data for every tab. If I could automate that process it would save me so much time. Thanks in advance, i've attached my worksheet. 

The Document in Question: https://***

[PII is masked by the moderator]

Answer 1

Hi,

There is no mistake in your formula.  Here is what i see on the POET worksheet.  I just went to cell A2, pressed F2 and then pressed Ctrl+Shift+Enter.  I then copied the formula down/right.

Answer 2

I'm familiar with Pivot Tables, I played around with that option before posting here. I'm looking for a VBA code. Thanks though.

Answer 3

You can make a PivotTable look pretty much exactly like its data source, it just takes some experimenting.

Answer 4

This option only auto populates certain parts of the data, based on filters. I need the data to replicate exactly the same from the master sheet to the sub sheets.

Answer 5

If you create a PivotTable from your master sheet, you can put Customer in the Filter field, then use the Show Report Filter Pages option, which will create a new PivotTable worksheet for each customer. As you add data, just refresh the PivotTables to update the information. No VBA required.