Validation Tables - how to get one to feed from another

[999HelpPlease]

I currently have one validation list.

Lets say it is different types of pets (dog, cat, bird, fish, etc) and that is in column A on Sheet 1. This is my current validation list and there are 15 different options to select from currently.

What I need to happen is if I select dog in column A and then I go to column B I want to select from a selection of breeds that I have in a different worksheet for the pets. I only want to see the breeds of dogs and not cats or any other pet to come up to keep this selection smaller.

Sheet 1
Column A Column B
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Dog[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]Fish


Sheet 2
Column A Column B
[TABLE="width: 182"]
<tbody>[TR]
[TD]Dog[/TD]
[TD]Fish[/TD]
[/TR]
[TR]
[TD]Golden Retriever[/TD]
[TD]Blow Fish[/TD]
[/TR]
[TR]
[TD]German Sheppard[/TD]
[TD]Gold Fish[/TD]
[/TR]
[TR]
[TD]Chow Chow[/TD]
[TD]Angel Fish[/TD]
[/TR]
[TR]
[TD]Maltese[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pug[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Boxer[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 182"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In this case when I am in Sheet 1 and in cell b1 I would like a validation list to select from all the dog breeds on my list. Nothing else should appear.

Is there a way to do this? I am having no luck finding a solution. I can do a basic validation list but I am unfamiliar with everything else. If you can supply as much detail as possible that would be great.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

What you need is dependant data validation, have a look here https://www.contextures.com/xlDataVal02.html

 

[999HelpPlease]

Thank you very much. I will give it a try and see how it works.

 

[Fluff]

You're welcome & good luck.