VBA or Formula Help - Lookup from Data into New Sheet

[Johnny Thunder]

Hi All,

Hoping this is a quick one.

I have a data sheet (Master) that contains a report of all the products in our inventory, I have a second sheet (dashboard) with a quick snapshots of Promotion Start/Lock dates. Not sure the best way to get the data into the sheet. It could be from a lookup or a Formula. I was leaning more towards the VBA route because I will be refreshing the Master Sheet 3 times a week so I will need a way to find the new last row of data and based on that it will drop in any new Products from the list.

For the dashboard sheet, I only need each product displayed once and I need a total of 8 items (Start/Lock Dates) I have 3 in the example. Any help is appreciated and if any clarifications can be made let me know. Thanks in advance!

Here is the Master Report

Book1
	A	B	C	D
1	Product	Item	Start Sale	Lock Date
2	Hammer	101	06/22/18	07/18/18
3	Hammer	102	07/16/18	07/29/18
4	Hammer	103	07/27/18	08/08/18
5	Hammer	104	08/09/18	08/21/18
6	Hammer	105	10/15/18	10/25/18
7	Hammer	106	10/26/18	11/07/18
8	Hammer	107	11/08/18	11/20/18
9	Hammer	108	11/21/18	12/10/18
10	Drill	101	07/04/18	07/18/18
11	Drill	102	07/15/18	07/29/18
12	Drill	103	07/25/18	08/08/18
13	Drill	104	08/07/18	08/21/18
14	Drill	105	10/11/18	10/25/18
15	Drill	106	10/24/18	11/07/18
16	Drill	107	11/06/18	11/20/18
17	Drill	108	11/26/18	12/10/18
Master

Dashboard Sheet

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Count	Product	Item 101	Start Date	Lock Date	Item 102	Start Date	Lock Date	Item 103	Start Date	Lock Date
2	8	Hammer		06/22/18	07/18/18		07/16/18	07/29/18		07/27/18	08/08/18
3	8	Drill		07/04/18	07/18/18		07/15/18	07/29/18		07/25/18	08/08/18
Dashboard

 

[Johnny Thunder]

Bump