Without looking at how your filters are setup, make sure the customer filter from Sheet1 is also applied to Sheet4. That way when you select Customer B on sheet1 the same filter is also applied to Sheet4.
Check Sheet 2 or 4 in your case,
Hope this helps,
It is applied. I have discovered that having only one sheet marked as target sheet in an action filter fixes it.
Good. If this helped, please mark the response as helpful and correct to close the thread.